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/sh...d.php?t=197127

http://www.thecodecage.com/forumz