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: Lela Lynch   on Nov 06

Worksheets("report").Cells(1, d).value = K(d)

(Not tested, but should be right.)

I don't think Worksheets has a Range member - if you want to specify
Worksheets as part of a range, they actually go inside the parentheses, as
part of the Range call's parameters. E.g.

Range (Worksheets("report").Cells(1, 1), Worksheets("report").Cells(1,
3)).etc

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: