Posted to microsoft.public.excel.worksheet.functions
|
|
Saving Worksheet "Name" in a Macro
Perfect ... thanks!
"FSt1" wrote:
hi
use variables.
Dim nam As String
Worksheets.Add.Name = Format(Date, "mmm dd yy")
nam = ActiveSheet.Name
Sheets("somesheet").Select
Sheets(nam).Select
variables are not stored permanently. when the sub finishes, all variable
are cleared from memory.
regards
FSt1
"ckrogers" wrote:
Hi. I have the following code (from a macro):
Worksheets.Add.Name = Format(Date, "mmm dd yy")
Sheets("Next List").Select
Range("A1:A25").Select
Range("A25").Activate
Selection.Copy
Sheets(Name).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Sheets(Name).Select
I'm a beginner in VB and Macros ... how can I "store" the name of the new
worksheet I've created so I can select the right worksheet for the
PasteSpecial command?
Any and all help will be appreciated!
Cindy
|