Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable not defined?
I just started writing some new code, went to test the first few
lines, but I'm getting a "variable not defined" error on the name of my subroutine. Anybody know what's wrong with the name? Sub WklySumWS() <------- VARIABLE NOT DEFINED Dim wbWkly As Workbook Dim wsWklyLst As Worksheet Dim wsWklySum As Worksheet Dim sWklyShtName As String Set wsWklyLst = ActiveSheet sWklyShtName = wsWklyLst.Name Sheets.Add.Activate wsWklySum = ActiveSheet ActiveSheet.Name = sWklyShtName & " Summary" End Sub Thanks for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Public Variable - not defined? | Excel Programming | |||
variable not defined | Excel Programming | |||
For Each cell - Variable not defined (VBA) | Excel Programming | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
[Q] msoShapeRectangle: variable not defined | Excel Programming |