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: Beaudi Smith   on Dec 22

Yes. Inside your range  call you are providing the range as a string. You
just need to use the appropriate string concatenation sequence to get the
range string you want. & (ampersand) is the string concatenation operator
in VBA.

range("A1:" & lastcolumn & lastrow)

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: