Posted to microsoft.public.excel.programming

ryguy7272

external usenet poster

Posts: 2,836

xlFillFormats; Fill 9 Columns to the Right

I'm not sure why my last post didn't show up; trying again:

ActiveCell.Resize(, 9).Select
'Selection.AutoFill Destination:=.Range(.Cells(, 9), Type:=xlFillFormats

This code fails on the second line (that's why it is commented out).
How can I make it run?

Thanks,
Ryan---
--
RyGuy

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
Fill other columns	slavenp	Excel Discussion (Misc queries)	3	October 24th 08 02:49 PM
Fill down two columns...C & D	J.W. Aldridge	Excel Programming	4	July 23rd 08 10:31 PM
fill in columns	widman	Excel Discussion (Misc queries)	1	October 16th 06 12:52 AM
Dynamic fill of columns	Jose Lopes	Excel Worksheet Functions	0	March 28th 06 10:07 PM
How would I fill a several columns with the value in the first row	BruceJ[_2_]	Excel Programming	3	September 24th 03 01:45 AM

All times are GMT +1. The time now is 05:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us