LinkBack URL
About LinkBacks
I am looking for a bit of vba in which I start with s specific cell and search down the column until I reach the first empty cell, and then selects that whole range from the starting cell to the last cell before the empty space. thanks in advance!
I am looking for a bit of vba in which I start with s specific cell and search down the column until I reach the first empty cell, and then selects that whole range from the starting cell to the last cell before the empty space. thanks in advance!
With B1 as the first cell try this--
Range(Range("B1"), Selection.End(xlDown)).Select
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
One of many ways
Please Login or Register to view this content.
Thanks guys they all work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks