how to search the upper and lower of a range

  • Thread starter Thread starter leungkong
  • Start date Start date
L

leungkong

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

Thanks.
 
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
Convert list to UPPER, lower & Proper cases. 21
Basic Range Question 1
scrolling 2 frames simultaneously 2
divide and copy rows 1
auto convert to upper case 1
Search lastname + firstname (search on uppercase) 2

Back
Top