| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Redefining a table range with a macro
Hello,
I need help creating code to redefine a table within a macro. I used the macro recorder to creata a table with the same name but to point to another locations. ActiveWorkbook.Names("Table1").Delete ActiveWorkbook.Names.Add Name:="Table1", RefersToR1C1:= _ "='Sheet1'!R3C28:R12C37" How do I make this dynamic, so the starting point, #of rows and # of columns are defined by variables? Help is much appreciated. Regards, OMER |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Redefining a Named Range In A Loop | Excel Programming | |||
| Redefining pivot table source | Excel Programming | |||
| Redefining a new Range area - Thanks Nick Hodge and Norman | Excel Programming | |||
| Redefining a new Range area | Excel Programming | |||
| Redefining Styles | Excel Programming | |||
Threaded Mode
