Hello, I want to apply this function to a range that I do not have to individually highlight on individual sheets. Can someone edit my code to make the range be columns W:AF but only going down to the last row in which there is data? So you could check column A for instance, to see if there is data. And the last row that column A has data, the last row the function will go through on W:AF. I would also like it to work over every worksheet.
Please Login or Register to view this content.
Last edited by bjcowen9000; 02-18-2013 at 09:18 AM.
if you want a fixed range you don't need a function, but a sub
you can define Myrange with
Please Login or Register to view this content.
If solved remember to mark Thread as solved
It needs to work with my function though
bjcowen9000,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks