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: Beau Smith   on Jan 30

Hopefully by now you've caught that your use of "lastrow" in your
cells reference is transposed.
It's supposed to be cells(row,column)
you're using cells(20,lastROW) which is backward.
These two are equivalent:
Range("B2:T" & lastrow).Select
Range(Cells(2,2),Cells(lastrow,20)).Select

I know, when using column LETTERS in the range  it's column,row
but when using Cell NUMBERS, it's row,column.

Does it work  now?

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: