52 Tips on
Windows 95/98 Great place to start mastering Windows 95
If you would like a macro
that ask you where you would like the name - use the following: (Remember on a module
sheet.)
Sub doit()
value1 = InputBox("Type cell address where you
want file name")
With ActiveWorkbook
Range(value1).Value = .FullName
End With
End Sub
If you just want a message box to tell you what the path is:
Sub GetPath()
MsgBox ThisWorkbook.FullName
End Sub
Remember you can have a button on your toolbar that runs your macro.
(Remember on a module
sheet.)
Select your area you want to copy over to a new sheet.
Hold down the Alt + Ctrl
Place your standard white pointer on the border of the selected area.
Press and drag to the sheet you want to move to.
When you touch the new sheet tab - that sheet will become active, then move your pointer
to the new locations. Let go of the mouse first then the Alt + Ctrl.
Subtotal problem. If you create subtotals and
then click the number 2 level button you get only the subtotals and grand total. This is
good - what we are after. Here is where the problem comes in, if you try to copy those
figures over to a new sheet and you get everything.
You get all of the figures not just the sub and grand.
Here is how to copy only the visible cells. (sub and grand)
Press F5
Click the Special... button
Select the option Visible cell only
Click OK
Click the Copy button or right click copy
On the new sheet - Right click and Paste
Now you have only the sub and grand totals.
To be able to toggle your view so you can see all of your
formulas, try this.
Select: Tools: Options...
Click: View (tab)
In the middle of the dialog box, click on "Formulas".
Now you can see all of the formulas on/in your spreadsheet.
| 
