Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets("MyName").select
Hi All........
Having trouble here with the lines of code Worksheets("MyName").select and Copy Destination:=Worksheets("MyName").Range("A1") where MyName is a variable, declared and set earlier.......I get "Runtime error 9, Subscript out of range" error and macro won't pass that point. How else might I be able to refer to that sheet whose name changes as the macro goes along....... TIA Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
Problem: Worksheets("New Style 2006").Unprotect Password:="naPrint" | Excel Programming | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE") | Excel Programming | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |