Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Carlton Martinez   on Feb 26 In MS Office Category.

  
Question Answered By: Kerry Wright   on Feb 26

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 1 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: