I Don't Want to Click and Drag

Parra · Apr 4th, 2002, 05:26 PM

I am importing data into Excel columns A through M. I add formulas to rows N through P. Is there a macro, to copy the formulas in N:P till the end of rows A:M?

Please help, Thanks.

Derek · Apr 5th, 2002, 01:25 AM

Hi
If you are only putting formulas on the first row, you can copy those formulas down by selecting them and dragging the fill handle downwards. If you do this whilst using the macro recorder you can then go to the VB Editor (Alt+F11) and see the code.
hope this is what you were after.
regards
Derek

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 05:26 PM	#1
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	I am importing data into Excel columns A through M. I add formulas to rows N through P. Is there a macro, to copy the formulas in N:P till the end of rows A:M? Please help, Thanks.

Apr 5th, 2002, 01:25 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi If you are only putting formulas on the first row, you can copy those formulas down by selecting them and dragging the fill handle downwards. If you do this whilst using the macro recorder you can then go to the VB Editor (Alt+F11) and see the code. hope this is what you were after. regards Derek