Below I have this marco the goes from row 2 to 2000(and that's okay), but I don't want to have to later in the year go and update this macor because it has exceed 2000 rows.
How can I put something like Range(Selection, Selection.End(xlDown)).Select, which goes to last record in place of 2 to 2000?
Please Login or Register to view this content.
Hi rlkerr,
Try this:
Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Keeps giving me a syntax error.
Please Login or Register to view this content.
Try this
andPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mike7952; 10-03-2012 at 02:10 PM.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
@ mike7952,
Thank you for helping out here Mike,
I was just going to ask for a sample WorkBook to see what the heck is going on. I have also slipped up badly by excluding the "2 To" bit.
I worked some. It just didn't go all the way to the bottom of the page. I have 280 rows and it stopped on row 23.
Please Login or Register to view this content.
Give this a try.
Please Login or Register to view this content.
Last edited by mike7952; 10-03-2012 at 03:31 PM.
Okay here is the stange thing. I was making you an example copy to look at and the macro works fine. It goes all the way to the bottom. But, in my actual sheet it only goes to 23. What should I be looking for? I'll keep playing with it.
Change this line:
toPlease Login or Register to view this content.
Please Login or Register to view this content.
In my post, Post #7 it looks for the last cell in Column BW. If BW will not have last cell in the row change this
Please Login or Register to view this content.
Last edited by mike7952; 10-03-2012 at 03:35 PM.
Fixed it. There was a #DIV/0 in column BV. So, made the formula an iferror..... Works fine. Thank you so much for your help. This is awesome. I apologize for it taking so long.
Please share with us, which line of Code, solved your problem. We are all here to benefit from feedback.
Hello rlkerr,
Thank you for adding to my Reputation.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks