Looping accross all worksheets in a workbook
I can only get my code to execute on the first worksheet in the workbook. I've tried to follow several suggestions that I've found online and in books. I'm stumped.It works great one worksheet at a time, but stops after the first worksheet. Can anyone help? I attached the document I'm working with, if that helps....
I have the following:
Please Login or Register to view this content.
Last edited by gspencer; 04-21-2011 at 04:08 PM. Reason: Needed to add code tags... I'm very new here!! thanks!
Thanks for the tip. I think I added the code tags correctly. I'm new to VBA, and this site.. I appreciate the help SO MUCH! Thanks!
I was just reading more past posts. I got an idea from a previous post.
I added one line to top of my code to select the worksheet.
Now my code looks like this and seems to be working:Please Login or Register to view this content.
This is my first day reading through this forum and I think I'm in love. Thanks!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks