Home » Forums » Open Source Learning Center » Question and Answer

macro code

Submitted by courtney hogan on 26 May, 2014 - 19:45

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

‹ Formula for If/or required please Help Modifying an Existing Excel Formula ›
»
Almir's picture

Check solution here

Submitted by Almir on 29 May, 2014 - 21:04.

Hi,check solution here:

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

»

Thanks very much. I did get

Submitted by courtney hogan on 29 May, 2014 - 21:09.

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

»

You want something like: x =

Submitted by chris on 29 May, 2014 - 17:25.

You want something like:

x = Range("PCH").Value

»