Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003: In a Macro,how to select a variable row length table
I wish to create a macro that will perform functions upon multiple rows of
data. The number of rows of data will change every time. Problem : I create a macro by recording. I select rows of data using CTRL/down arrow on the last column and then selecting back to the first column of the first data row. This appears to 'hard code' the number of rows of data to be the number of rows that exists at the time of macro creation. When I run the macro another time it then selects the same number of rows as when the macro was created, which will then not match the new current data. i.e. some rows are left unselected. |
#2
|
|||
|
|||
Hi Tonto
One way is to use Dynamic range http://www.contextures.com/xlNames01.html#Dynamic Or see example 1 and 3 on this page for other ways http://www.rondebruin.nl/delete.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Tonto" wrote in message ... I wish to create a macro that will perform functions upon multiple rows of data. The number of rows of data will change every time. Problem : I create a macro by recording. I select rows of data using CTRL/down arrow on the last column and then selecting back to the first column of the first data row. This appears to 'hard code' the number of rows of data to be the number of rows that exists at the time of macro creation. When I run the macro another time it then selects the same number of rows as when the macro was created, which will then not match the new current data. i.e. some rows are left unselected. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINEST bug with cubic polynomials in Excel 2003 | Excel Worksheet Functions | |||
Upgrade from Excel 97 to 2003 | Excel Discussion (Misc queries) | |||
In Microsoft Excel 2003, when I select a color for a cell it does. | Excel Worksheet Functions | |||
Excel 2003 V's Excel 2000? | Excel Worksheet Functions | |||
quattro pro converter Excel 2003 | New Users to Excel |