Copy and paste in VBA

Posted to microsoft.public.excel.programming

AM[_3_]

external usenet poster

Posts: 1

Copy and paste in VBA

I want to copy the formula in E7 down to the number of
rows that contain data in columns A through D. But this
number may vary. In this example the last row with data
will be 12,073. How can I get VBA to take this into
account?

Range("E7").Formula = "=Sum(B7:D7)"
Range("E7").Copy Destination:=oWorksheet.Range("E8:E12073")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't Copy and Paste or Paste Special between Excel Workbooks	wllee	Excel Discussion (Misc queries)	5	April 29th 23 03:43 AM
Copy; Paste; Paste Special are disabled	Mack Neff[_3_]	Excel Discussion (Misc queries)	0	April 28th 08 06:29 PM
Excel cut/Paste Problem: Year changes after data is copy and paste	Asif	Excel Discussion (Misc queries)	2	December 9th 05 05:16 PM
I cannot paste from one workbook to another. Copy works, paste do.	JimmyMc	Excel Discussion (Misc queries)	1	June 10th 05 03:54 PM
Macro to Copy/Paste then Paste to Next Line	tomkarakowski	Excel Programming	1	May 28th 04 01:19 AM

All times are GMT +1. The time now is 06:22 AM.

Menu

About Us