Resize a range
Thanks
"Tom Ogilvy" wrote:
Assume it is a named range with a name of Data
Range("Data").currentRegion.Name = "Data"
or
set rng = range("Data")
rng.Resize(rng.rows.count+1).Name = "Data"
--
Regards,
Tom Ogilvy
"Oldjay" wrote:
I have a range of records. i want to add a new record and then resize the range
|