Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Declaring a Cell reference as a variable

  Asked By: Sean    Date: Jan 29    Category: MS Office    Views: 817
  

I am trying to loop through a list of Account Managers that can vary
in length to create a summary for each Account Manager.

I am trying to format each summary which takes up 13 rows for each
Account Manager and then populate data from another worksheet.

I want to start at Cell B5 run the formatting code then as long as
Account Manager list <> "" move to start point + 13 rows and run the
formatting code again.

I am happily looping through the Account Manager list. But I don't
know how to declare "StartPos" as B5 and then change to StartPos +
13 rows i.e. B18.

I hope this makes some sort of sense. Thanks in advance for the
help!

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Ujala Hashmi     Answered On: Jan 29

Use

For J = 5 to 9999 step 13

 
Didn't find what you were looking for? Find more on Declaring a Cell reference as a variable Or get search suggestion and latest updates.




Tagged: