| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find last row through a macro
I have data in column A. The last row filled is row number 20
I have a formula in cell C1. I want to detect the last filled row in column A (in this example, it is row no.20) Once the detection is over, the vba should drag formula in C1 till C20. The next day I will paste some more data in column A. After running the same macro, again the same thing should happen. Detect the NEW last row number and drag formula from C1 till CXX (XX=NEW last row) Can anybody help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MACRO find and Go-To | Excel Discussion (Misc queries) | |||
| Get Macro warning, but can't find Macro | Excel Worksheet Functions | |||
| change error message when no more for "find" in macro to find | Excel Programming | |||
| Using Find in a macro | Excel Discussion (Misc queries) | |||
| I need to find a macro to find data cut and paste to another colu. | Excel Programming | |||
Threaded Mode
