Prev: Using VBA to create PDF - setting paper size
Next: Object Browser
From: Edgar on 20 Apr 2010 17:09
Hello,

I currently have a workbook with 36 sheets within for a production report.
The workbook is set up with a 1 monthy total sheet, 5 week total sheets and 6
days sheets per week. I also have a macro set up on one sheet that will auto
rank one (production) column which then would re-arrange the employee's names
from highest to lowest based upon the (production) column. Here is the
problem I would like to apply this macro to all 36 sheets, however, when run
this marco it will only adjusted the the sheet where the macro was originally
created upon. Now I could just create separate macro for each sheet, however,
that would consume much of my time. Is there an easier way?

Thanks!
From: joel on 20 Apr 2010 17:21

It would help if you posted the code. specifying the sheet in the
macro usually solves this problem. Something like this


for each sht in sheets
with sht

.range("A1") = sht.name
end with

next sht

the above code will go through the entire workbook and put the sheet
name of each sheet in cell A1.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=197127

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Using VBA to create PDF - setting paper size
Next: Object Browser