Taking values from cells for use in Macros

I am writing a for loop in a macro to loop as shown

For i = 1 To #
Perform Task
Next i
End

In the worksheet i am using this macro i want to specify the number of iterations for the loop to perform by placing an integer value in a cell, i then want the value i put in the cell to replace the # in the macro, what do i put in the code instead of the # to do this??

Thankyou in advance

Hi. Please read forum rules before posting:

http://www.excelforum.com/showthread.php?t=591596

You must wrap your code using the # symbol located in the reply window.

To answer your question, you need to assign a variable to the applicable cell. For example, assume you are using cell A1:

Please Login or Register  to view this content.

HTH

Jason

Use the Value property. worksheet(1).cells(1,1).value