Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Bryant Smith   on Jan 30 In MS Office Category.

  
Question Answered By: Ramond Fischer   on Jan 30

How about just using something Paul suggested and saying:

Range("B2:T" & lastrow).Select



The other way, using .Cells, works too, but if you want to specify B2 thru
T<lastrow>, you've got to use:

.Range(.Cells(2, 2), .Cells(lastrow, 20)).Select



It goes .Cells(Row, Column), not .Cells(Column, Row).

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on highlight a range using a named range Or get search suggestion and latest updates.


Tagged: