Background can be found here
http://www.excelforum.com/showthread.php?t=582713
That macro worked beautifully!! Now I have a workbook with 500+ worksheets....my first worksheet is a unique page; and then the following one (worksheet name "AA") has column names, frozen window panes, date format, and borders. I want all of the other worksheets to have the same "format" as the others....I don't want to ctrl + a, ctrl + c, pick the next workbook, ctrl + v 500+ times!!! anyone know of a faster way?
also......this is probably easy but I can't figure it out....everytime I enter 001 it makes it 1....I don't want that....how can I make excell not remove my important zeros?
Thanks for listening, thinking, replying!!! Ever since I've found this website everyone has been very very very extremely helpful....THANKS!!!! Hopefully i'll be good enough at this stuff to return the favors.....If anyone needs pro/e work i'm there!!! thanks!
Bookmarks