Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

Coding problem

Would someone please show me what is the correct way to code the
following so that my AutoFill Destination goes from Cells(27,2) to
Cells(27,numberofRows)?

ws1.Range("A2").Select
numberofRows = ActiveCell.CurrentRegion.Rows.Count

Selection.AutoFill Destination:=ws1.Range("AA2:AA822"),
Type:=xlFillDefault

Thanks,
Jim Berglund

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
Help with my coding problem?	Dan the Man[_2_]	Excel Worksheet Functions	3	September 11th 07 12:02 AM
If, Then, Else Coding Problem	BEEJAY	Excel Programming	4	May 30th 06 08:26 PM
problem with coding	Subs	Excel Programming	5	September 26th 05 03:56 PM
Please help: Coding Problem	Tim	Excel Programming	4	June 28th 05 05:41 AM
Coding problem	John[_105_]	Excel Programming	3	June 22nd 05 05:39 PM

All times are GMT +1. The time now is 11:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us