| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help
Yes, but only after you've captured the value of FinalRow with the assignment
FinalRow = Selection.Row following the xlDown. And be careful with the quotes... In the original code, a line like "D5:D101" has quotes to indicate a string. You'd replace that with "D5:" & FinalRow. You still need to get the quote AFTER the string literal (D5:), or you'll wind up with compile errors. "JasonP CCTM LV" wrote: The "101" referenced in the macro comes from the fact that the table I created the macro with had 101 rows. So all I need to do is replace that "101" with "& FinalRow" ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Threaded Mode
