Use the cells method in your macro to set the value of the loop counter.

In the following example, the statement returns the value in Cell A3

loop_counter=Cells(3,1)



"ocset" wrote:

hi,
I want to use a cell in a worksheet to control a loop counter

cell A1 in worksheet `Test `= x
I also want to show the value of x as it increase / decrease on a
worksheet ( i beleive I use print but not quite sure how)

how do i display the cell link(my intial value of x) inside my macro

how do I show link to display the decrease or increase of the value of x
inside a worksheet
any assistance appreciated