etpeterson
New Member
- Joined
- Jan 19, 2005
- Messages
- 18
I have to do an auto fill of a formula I copy to a cell inside of a macro. I pre recorded the macro so the code looks like this,
Selection.AutoFill Destination:=Range("I24:I123")
This code needs to execute on different worksheets that will be different lengths. My "selection" changes properly depending on what worksheet I am in, but the range of the auto fill does not. What should I do?
Thanks,
Eric
Selection.AutoFill Destination:=Range("I24:I123")
This code needs to execute on different worksheets that will be different lengths. My "selection" changes properly depending on what worksheet I am in, but the range of the auto fill does not. What should I do?
Thanks,
Eric