how to search the upper and lower of a range

L

leungkong

I want to search the upper and lower row of a range.
for example,
Range("B3:E10")
Upper = "B"
Lower = "E"

Thanks.
 
P

paulgu

Joined
Apr 29, 2008
Messages
66
Reaction score
0
Well B & E are the first and last *columns* of the range. In code you could use:
Upper = Range("MyRange").Column
Lower = Upper + Range("MyRange").Columns.Count - 1
and something similar would also work with rows.
HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Good code, need one more step 3
Selecting Range between two named ranges 7
Basic Range Question 1
Convert list to UPPER, lower & Proper cases. 21
scrolling 2 frames simultaneously 2
auto convert to upper case 1
Search lastname + firstname (search on uppercase) 2
Changing numerical values based upper and lower range 4

Top