zsnow_girl
New Member
- Joined
- Aug 18, 2008
- Messages
- 5
Hi,
I'm having problems with macros. I'm creating huge files by copying down a formula within the macro to the end of the known universe. (Then I have to go into each file and delete it all by hand which often crashes my PC)
ActiveCell.FormulaR1C1 = "=RC[-3]-RC[-1]"
Range("F1:G1").Select
Selection.AutoFill Destination:=Range("F:G")
Range("F:G").Select
The macro runs through files of differing sizes. So how do I say I only want it to copy to the bottom of the table?
This probably has a simple solution. I just can't find it!
Please help,
Thanks
I'm having problems with macros. I'm creating huge files by copying down a formula within the macro to the end of the known universe. (Then I have to go into each file and delete it all by hand which often crashes my PC)
ActiveCell.FormulaR1C1 = "=RC[-3]-RC[-1]"
Range("F1:G1").Select
Selection.AutoFill Destination:=Range("F:G")
Range("F:G").Select
The macro runs through files of differing sizes. So how do I say I only want it to copy to the bottom of the table?
This probably has a simple solution. I just can't find it!
Please help,
Thanks