Posted to microsoft.public.excel.programming

Jim Rech

external usenet poster

Posts: 2,718

Macro Code Question for Newbe

There are many way to do that. Here's one:

Range("B1", Range("B1").End(xlDown)).Offset(0, 1).FillDown

--
Jim Rech
Excel MVP

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
macro code question	Maria	Excel Discussion (Misc queries)	6	March 7th 09 08:44 AM
newbe with a formula question.	David franklin	Excel Discussion (Misc queries)	5	February 4th 08 06:03 AM
A macro code question from a novice	Richard	Excel Discussion (Misc queries)	2	December 24th 07 07:22 PM
Newbe trying to do Dynamic Parameters from a Worksheet	Sean Cooper	Excel Discussion (Misc queries)	0	January 22nd 07 02:56 PM
Newbe help with a lookup	Cybertech	Excel Discussion (Misc queries)	2	January 13th 06 09:53 PM

All times are GMT +1. The time now is 07:23 PM.

About Us

"It's about Microsoft Excel"