| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
do something for each sheet
thank you, that worked.
"Vergel Adriano" wrote: You need to qualify the Range object with varSheet and it's also better to declare varsheet as a worksheet object rather than variant. like this: Sub proTest() Dim varSheet As Worksheet For Each varSheet In Worksheets varSheet.Range("A1").Value = 22 Next End Sub -- Hope that helps. Vergel Adriano "rodchar" wrote: hey all, i found this snippet on the net but it doesn't seem to be working for me: Sub proTest() Dim varSheet As Variant For Each varSheet In Worksheets Range("A1").Value = 22 Next End Sub It only puts it into the current active sheet. can someone please tell me how to run it for each sheet or what i'm doing wrong in the preceding snippet? thanks, rodchar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
| Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming | |||
Threaded Mode
