BIGTONE559
Active Member
- Joined
- Apr 20, 2011
- Messages
- 336
Hello,
I'm trying to understand the syntax for running the same functions on multiple worksheets in the workbook. I would like to check each page cell J6 for a date >07-1-11 if that condition is true i want to copy Cell "J6" and Range(Cells(cell.row,11,cell.row,13)) (from that respective worksheet) to Sheet1
I've noticed a lot of references to
however when it runs it only runs on the activesheet
Using Excel 2007 by the way
I'm trying to understand the syntax for running the same functions on multiple worksheets in the workbook. I would like to check each page cell J6 for a date >07-1-11 if that condition is true i want to copy Cell "J6" and Range(Cells(cell.row,11,cell.row,13)) (from that respective worksheet) to Sheet1
I've noticed a lot of references to
Code:
Dim ws as worksheet
for each ws in activeworkbook.activeworksheet
'enter code here
Using Excel 2007 by the way
Last edited: