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!
AvantGuardDogAsked:
Who is Participating?
 
Anthony BerenguelConnect With a Mentor Commented:
ssaqibh, I made a minor adjustment (to go to the first blank cell) to your example to meet the requirements of the user.

Range("A2").End(xlDown).Offset(1).Select

Open in new window

0
 
Anthony BerenguelCommented:
How are you referring to your range? Have you defined it as a range object?
0
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Something like

Range("A2").end(xldown).select
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Saqib Husain, SyedEngineerCommented:
Very much appropriate....Thanks aebea...the credit goes to you

Saqib
0
 
Anthony BerenguelCommented:
No, no. If anything it should be shared ;-)
0
 
AvantGuardDogAuthor Commented:
Thank you ssaqibh and aebea ! ssaqibh's solution combined with aebea's minor adjustment worked perfectly, like a charm.  Very much appreciated!
0
 
Anthony BerenguelCommented:
Thank you for sharing the credit, AvantGuardDog. Also, i like the wordplay in your username ;-)
0
 
AvantGuardDogAuthor Commented:
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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.