Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Archie Evans   on Dec 22 In MS Office Category.

  
Question Answered By: Andrew Brown   on Dec 22

Yes you can do this.
Get value of lastcolumn & lastrow in to any variable eg. "f"
& use it inside the range  input as range1 = range("A1:A"&f)

Share: 

 

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

 
Didn't find what you were looking for? Find more on Reference range row and column in VBA Or get search suggestion and latest updates.


Tagged: