Macro - VBA code to look at a cell rather than a hard-code

[Jeff12]

The macro goes through 89 different items but rather than me type in 89 in VBA how can I link the 89 part to a cell (which is a name range called CounterW) which is doing a countif function and will change regularly? thanks in advance


x = 1 To 89


Sheets("Summary").Select
Range("e6") = x
Calculate

 

[Jonmo1]

You can refer to a named range in VBA like

Range("CounterW").Value

 

[Jeff12]

thank you very much