Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-defining Ranges in VBA
Can anyone help please? I have a macro which imports data, replacing data
which is already there and has been range named. When the import has finished, the range name re-defines itself and cuts out some of the columns and rows that were originally there. Is there a way in VBA that I can get therange name to automatically re-define itself based on the new current region so that it sees all of the new data? I'm new at this and I'm struggling, so any help would be really appreciated Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-defining Ranges in VBA
Once all of your cutting and pasting is done you can use code something like
this... ThisWorkbook.Names.Add "RawData", Range(activesheet.Range("A65535").End(xlUp), activesheet.Range("C1")) This code creates a named range (RawData) from from the last row of data in column A to the first row in column C... HTH "aehan" wrote: Can anyone help please? I have a macro which imports data, replacing data which is already there and has been range named. When the import has finished, the range name re-defines itself and cuts out some of the columns and rows that were originally there. Is there a way in VBA that I can get therange name to automatically re-define itself based on the new current region so that it sees all of the new data? I'm new at this and I'm struggling, so any help would be really appreciated Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-defining Ranges in VBA
THANKYOU!!!!!
"Jim Thomlinson" wrote: Once all of your cutting and pasting is done you can use code something like this... ThisWorkbook.Names.Add "RawData", Range(activesheet.Range("A65535").End(xlUp), activesheet.Range("C1")) This code creates a named range (RawData) from from the last row of data in column A to the first row in column C... HTH "aehan" wrote: Can anyone help please? I have a macro which imports data, replacing data which is already there and has been range named. When the import has finished, the range name re-defines itself and cuts out some of the columns and rows that were originally there. Is there a way in VBA that I can get therange name to automatically re-define itself based on the new current region so that it sees all of the new data? I'm new at this and I'm struggling, so any help would be really appreciated Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-defining Ranges in VBA
Unless you have set the range definition up as a dynamic range, it wouldn't
be automatic, but since you are running code to make the changes, just add a line similar to this. Range("A1").CurrentRegion.Name = "MyName" -- Regards, Tom Ogilvy "aehan" wrote in message ... Can anyone help please? I have a macro which imports data, replacing data which is already there and has been range named. When the import has finished, the range name re-defines itself and cuts out some of the columns and rows that were originally there. Is there a way in VBA that I can get therange name to automatically re-define itself based on the new current region so that it sees all of the new data? I'm new at this and I'm struggling, so any help would be really appreciated Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining a name that represent identical ranges in every sheet | Excel Discussion (Misc queries) | |||
Defining Ranges | Excel Worksheet Functions | |||
Defining Dynamic Ranges in Macro | Excel Programming | |||
Defining ranges in VB code | Excel Programming | |||
Defining Ranges | Excel Programming |