Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use a Macro to define a Named Range
I have a spread sheet in which I have to continually update a named range.
The number of columns is static and the number of rows grow with new information every day. The named range includes columns A thourgh CX. There my not always be an entry in Column A. The first Column where there will always be information is column B. How do I use a macro to do this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use a Macro to define a Named Range
Roedd <<EKUFan wedi ysgrifennu:
I have a spread sheet in which I have to continually update a named range. The number of columns is static and the number of rows grow with new information every day. The named range includes columns A thourgh CX. There my not always be an entry in Column A. The first Column where there will always be information is column B. How do I use a macro to do this. No macro required. Assuming your sheet is called Sheet1, Create a name referring to the function =Sheet1!$A$1:OFFSET(Sheet1!$B$1,COUNTA(Sheet1!$B:$ B)-1,100) This range will expand as rows are added. Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I have a cell value define a dynamic named range? | Excel Worksheet Functions | |||
Define Named Range | Excel Programming | |||
How to define a relative named range in VBA | Excel Programming | |||
How to define a Named Range in VBA? | Excel Programming | |||
Define a range based on another named range | Excel Worksheet Functions |