Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I found this in the help file:
Worksheets("Sheet1").Activate Do I need to use this .activate command and then this: with worksheets("sheet1") .range("A1") = "foo" .cells(2,1) = .range("A1") end with ....or can I just use this with command to activate whichever sheet I'm refering to? thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare Rows on different Worksheets and Output Difference's to other Worksheets. | Excel Programming | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
VBA / Macro for creating new worksheets and new columns from existing worksheets | Excel Programming | |||
Bypassing Worksheets when scanning worksheets for data | Excel Programming | |||
Need code to protect worksheets - amount of worksheets varies | Excel Programming |