Copy down X number of times

[hatstand]

HI All,

What I thought was a simple thing to do, I'm struggling to solve. I'm trying to modify this line:

Range("A2").AutoFill Destination:=Range("A2:A10"), Type:=xlFillSeries

I trying to copy down a formula a set number of times based on a cell value or a declared value.

Am I missing the obvious?

 

[niceguy_jay]

what is the error that you are getting ??

 

[hatstand]

Hi,

I don't get an error. It only copies down the range specified. i.e. A2:A10. I would like to be able to enter a figure in a cell and the formaula is filled down that number of times.

 

[Trebor76]

Hi hatstand,

If the value is in cell A1 (change to suit) try this:

Range("A2").AutoFill Destination:=Range("A2:A" & Range("A1").Value + 1), Type:=xlFillSeries

You would use the same concept for a declared variable.

HTH

Robert

 

[hatstand]

Thanks so much. I've just spent the best part of 2 hours trying to do that. Your help is very appreciated.

 

[Trebor76]

Glad to have helped