Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I know this should be simple, but I'm pretty new to VBA and can't seem to get
it to work. My code: Dim myWbk as Workbook Dim ws1 as Worksheet Dim ws2 as Worksheet Set myWkb = ActiveWorkbook It never sets the value of the variable, so when I try: Set ws1 = myWbk.Worksheets("Individuals") I get "Run Time Error 91 - Object variable or With block variable not set" What in the world am I doing wrong? Thanks, Cheryl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
variable not defined, ActiveWorkbook.name | Excel Programming | |||
set variable to activeworkbook | Excel Programming | |||
Setting a Variable range in VBA | Excel Programming | |||
'ActiveWorkbook.Names.Add Name:' how to make range variable? | Excel Programming | |||
setting a range variable equal to the value of a string variable | Excel Programming |