macro code

I am trying to write a macro code that will repeat x number of time based upon a cell in my excel spreadsheet. Let say I have a cell with a range name as PCH and PCH tell me how many time I want to do a task. So I need to know how I can get VBA to read the range PCH and repeat the operating based upon PCH value.

Thanks

Almir's picture

Check solution here

Hi,check solution here:

www.excelexperts.com/solution-macro-code-will-repeat-x-number-time-based...

Thanks very much. I did get

Thanks very much. I did get an earlier reply and I guess I need to notify the board.

You want something like: x =

You want something like:

x = Range("PCH").Value