I don't get this error.

Can you explain what you did , and post the whole code that you used.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"J" wrote in message
...
Thank you for your help.

When attempting to use this, I get
"Run-time error '449':
Argument not optional."

My ignorance is such that I don't know what argument I am missing.

Any suggestions or direction is appreciated.

"Bob Phillips" wrote:

I guess that you mean

iLastRow = Cells(Rows.Count,"A").End(xlUp).Row
With Worksheets("Sheet1").Range("A1")
.Autofill .Resize(iLastRow)
End With

--

HTH

RP
(remove nothere from the email address if mailing direct)


"J" wrote in message
...

What is a simple way (in a macro) to copy a formula down an empty
column
and only paste the formula if data exists on that row?

I've used {Worksheets("Sheet1").Range("A1:A100").FillDown} when I know
how
many rows have data, but in this case I don't have any idea how many
rows
there may be with data.

Thanks for any help.