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: Janelle Evans   on Nov 06

I goofed on that last transmission!

If "K" is a defined  range somewhere in the worksheet or workbook and you are
looking to copy to a vertical contiguous cell range, then try

target = Sheets("sheet3").Index
For co = 1 To 17
Sheets(target).Cells(co, 1) = Range("k")(co)
Next co

Also, is this array  'K' generated by some VB code  earlier in the process?
Your original version appears to copy the K range to a diagonal range of cells!
Is this correct? Based on the line items d=1 & following d=d+1 in the loop
structure.

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: