AvantGuardDog
asked on
Using VBA in Excel, how do I set VB code to goto the first blank cell after a range?
I need my VB code to find / goto the first blank cell after a range, so data can be copied there as the next set of records chosen by a user (a previous set already chosen, that is the previous range to find the next blank cell below).
Thank you!
Thank you!
How are you referring to your range? Have you defined it as a range object?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Very much appropriate....Thanks aebea...the credit goes to you
Saqib
Saqib
No, no. If anything it should be shared ;-)
ASKER
Thank you ssaqibh and aebea ! ssaqibh's solution combined with aebea's minor adjustment worked perfectly, like a charm. Very much appreciated!
Thank you for sharing the credit, AvantGuardDog. Also, i like the wordplay in your username ;-)
ASKER
You are welcome aebea :-) once again, thanks!
ssaqibh, thank you again also, both of your efforts are extremely helpful, and it is very much appreciated!
ssaqibh, thank you again also, both of your efforts are extremely helpful, and it is very much appreciated!