Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Properties of a Range object after initial Dimensions ??
Hi there I don't know if this is posible or not but I would like to think so.
Sub Test() Dim BaseDateRng As Range Set BaseDateRng = Worksheets("Sheet1").Range("A2:D10") 'This line below is wrong and doesn't work Set BaseDateRng = BaseDateRng.Row - 1 End Sub What I am trying to do is change just the Row property of my range object without having to redeclare it as... Set BaseDateRng = Worksheets("Sheet1").Range("A1:D10") I should be able to just alter reset or redim or something the "row" property of my range object. Is this posible and if so what is the corect syntax for doing it ?? Thanks, Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 97 keeps changing dimensions of autoshape rectangle | Excel Discussion (Misc queries) | |||
Inserting blanks or changing dimensions | Excel Worksheet Functions | |||
Properties of QueryTable Object | Excel Programming | |||
OLE Object -TexBox Properties | Excel Programming | |||
iterating through all properties of an object | Excel Programming |