Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resize a range
I have a range of records. i want to add a new record and then resize the range
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range.Delete and Range.Resize.Name performance issues | Excel Programming | |||
Range resize | Excel Programming | |||
Resize Range Question | Excel Programming | |||
Range Resize | Excel Programming | |||
Range Resize property | Excel Programming |