I am having a problem with my code not looping through any sheets. I used case to exclude a couple of the sheets from hardcoding. It runs through the code and just keeps pasting on the same sheet over and over without moving to any other sheets. Anyone got any idea why this is happening. Thanks.
Please Login or Register to view this content.
Insert:
immediately after the For statementPlease Login or Register to view this content.
Gary's Student
Hi,
When you do a "Range( ).Select" it works on the active sheet (the one you are viewing). You will either need to Select your different sheets in the code or do a With Worksheets( ) type of statement in your code to get data from different sheets.
Look at http://www.ozgrid.com/VBA/sheet-index.htm for the example.
Note - when using the WITH Worksheets type of code ".Range" is dealing on the WITH sheet and "Range" is dealing with the current/viewed sheet.
This period in front of Range or Cell is such a small dot but it has such GREAT meaning.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you both for the explanation and the fix. Much Appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks