Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
02-04-2005, 07:59 PM #1
- Join Date
- Feb 2005
- Thanked 0 Times in 0 Posts
Excel Macros - Selection.AutoFill Destination
I have created a macro with a few autofills.
Looks like this:
ActiveCell.FormulaR1C1 = "=SUM(RC[-1]*0.2)"
I will use this macro on a daily basis & the problem is the # of rows changes from day to day. What do I need to change to 'get' the last row & use that row number in the above example?
So if the last row was 19000, my range would be C2:19000.
Thanks in advance for your help!