Autofill Destination range open

Posted to microsoft.public.excel.programming

J.W. Aldridge J.W. Aldridge is offline

external usenet poster

Posts: 425

Autofill Destination range open

recorded this line in a macro....

Need for this to read as an open range instead of stopping at F784.
Will always start at A2- F2 but last row (F784) may change..

Selection.AutoFill Destination:=Range("A2:F784")

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
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?	[email protected]	Excel Programming	2	March 13th 07 12:10 PM
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?	[email protected]	Excel Programming	0	March 13th 07 02:22 AM
Range("B2").AutoFill Destination:=Range("GX1", ActiveCell) ... Fails but why?	[email protected]	Excel Programming	0	March 13th 07 02:16 AM
Selection.Autofill Destination:=Range(ActiveCell.Value)	[email protected]	Excel Programming	6	April 23rd 06 11:15 PM
Help with "Autofill" Destination Range	Joe MacPherson	Excel Programming	0	May 6th 04 06:03 PM

All times are GMT +1. The time now is 10:28 PM.

Menu

About Us