Hi All
I need to delete the contents of 63 worksheets in a workbook in a specific range, I wrote the following code but all it does is delete the first sheet 63 time and does not move onto the other sheets, can someone help/explain my problem.
Many thanks
Please Login or Register to view this content.
Alan
Excel 2007
Last edited by drums4monty; 02-13-2011 at 11:18 AM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi,
When referring to a range, if you do not specify the worksheet containing the range it's assumed that you are referring to the active sheet. Try changing the code to:Please Login or Register to view this content.
You should also note that you don't need to select a range to modify it, therefore you can shorten it to:Please Login or Register to view this content.
Cheers,
Dom
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