Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Magenta Ricci   on Nov 06 In MS Office Category.

  
Question Answered By: Mark R   on Nov 06

You can avoid the For.. Next loop

Try this:

Sheets("report").Activate
Range(Cells(1, 1), Cells(1, 17)) = K

Or if you want to keep the upper range of K flexible, then try:

u = UBound(K)
Sheets("report").Activate
Range(Cells(1, 1), Cells(1, u)) = K

Share: 

 

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

 
Didn't find what you were looking for? Find more on Populate array value using For Next loop Or get search suggestion and latest updates.


Tagged: