Try this

range(activecell,activecell.End(xlDown)).formula=" =bla bla bla"

--
Regards
PY & Associates

"neilriches" wrote
in message ...

I need to create a macro that fills a formula down to the last row in a
worksheet.

The problem is the number of rows in the worksheet varies so I can't
simply use the basic fill down action.

Help!


--
neilriches
------------------------------------------------------------------------
neilriches's Profile:
http://www.excelforum.com/member.php...o&userid=27161
View this thread: http://www.excelforum.com/showthread...hreadid=466734