Why not just

Range("A1:A30").FormulaR1C1 = ...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ward376" wrote in message
ups.com...
I want to select a range in a single column within the currentregion -
for example I have a table with a heading and records in a1:d30 and
want to fill the first column with a formula or value -

Thanks!