Fill formula with code

[WhiteKelso]

Hi all,

Here's my problem:

I have a number in cell G5.

I need help for a macro so that, for a definite number of times, a formula (G5 +1) will appear starting at G6 downwards. I think a FOR NEXT loop would work, but I'm clueless on what to do.
It may look like this:
For i = 1 to 25
copy a formula downwards 25 times
next i

Please help. Thanks again for being there.


WK

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[WhiteKelso]

Maybe

Please Login or Register  to view this content.

VBA Noob

Doesn't seem to do anything at all.

Any more idea please.

[VBA Noob]

Missed off the G5 + 1 bit

Try

Please Login or Register  to view this content.

VBA Noob

[WhiteKelso]

Missed off the G5 + 1 bit

Try

Please Login or Register  to view this content.

VBA Noob

THanks a million. Works perfectly. (you're not a noob, of course; it would have taken me a million years to figure this one out. reference materials only helped to a limited extent. glad there's a forum like this. thanks again.)

WK