| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Setting a variable cell address
I'm trying to run a macro.
The data can change in row length from spreadsheet to spreadsheet. I want to find the end of the data (i.e row 20 or row 1000) and in the next row set up various arrays. Obviously the 'shft' + 'ctrl' down arrow takes me to the end bottom of the data, but the macro then sets absolute address so the next spreadsheet gets the wrong parameters. Any ideas? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
| How do I dynamically retrieve the cell address of the last cell t. | Excel Discussion (Misc queries) | |||
| How can I insert a cell reference in a footer (eg for variable foo | Excel Discussion (Misc queries) | |||
| How can I insert a cell reference in a footer (eg for variable foo | Excel Discussion (Misc queries) | |||
| Cell reference - for the sheet name, can I use a variable? | Excel Discussion (Misc queries) | |||
Threaded Mode
