Resize a range
 

I have a range of records. i want to add a new record and then resize the range

Resize a range
 

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

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