| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a dynamic range in a macro
I am designing a macro for a user that takes a range of data and moves it
from one column to another and then clears the data from the original column at the beginning of the day. The problem is that new rows are added every few days and the range in the macro does not update. This causes data not to be moved at start of day. I have formulas below the range I want to move so I can't set the range to large as to clear out the formulas. Does anyone know how to have the range in the macro change as the range in the worksheet changes? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range Name affecting speed of macro | Excel Worksheet Functions | |||
| Copy/Paste using a macro that identifies occuoied range | Setting up and Configuration of Excel | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
Threaded Mode
