| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to find end of rows and print message
I have this recorded macro:
Sub Macro2() Selection.SpecialCells(xlCellTypeLastCell).Select Range("I41").Select Selection.End(xlToLeft).Select ActiveCell.FormulaR1C1 = "this is a test" Range("B41").Select End Sub How can I get it to go to the bottom of the data regardless of the number of rows? Ain't I a dummy?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to find and paste rows | Excel Discussion (Misc queries) | |||
| Macro to find and delete rows! | Excel Discussion (Misc queries) | |||
| Macro to: Find a Reference, and then Paste into the 10 Rows Below | Excel Discussion (Misc queries) | |||
| Macro - message box if find nothing | Excel Discussion (Misc queries) | |||
| macro to not print blank value rows in invoice | Excel Worksheet Functions | |||
Threaded Mode
