Posted to microsoft.public.excel.programming

Woody[_3_] Woody[_3_] is offline

external usenet poster

Posts: 14

FillDown from unknown column

I'm adding a formula to a column that I don't know in advance, and I need
to fill the formula down the same number of rows as there are in column A.

If I knew the column, I would do something like:

LastRow = Cells.SpecialCells(xlLastCell).Row
Range("F1:F" Trim(Str(LastRow))).FillDown

How can I do this?

Thanks,
Woody

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
SUM IF - What if column number is unknown	Milind Keer[_2_]	Excel Discussion (Misc queries)	3	October 23rd 08 05:22 PM
Unknown # cells need to be in one column - Macro	[email protected]	Excel Discussion (Misc queries)	2	May 28th 06 08:33 PM
A function that looks for a value on a sheet on unknown column or row	Paul134	Excel Worksheet Functions	2	February 28th 06 09:07 PM
FillDown	Mike Fogleman	Excel Programming	2	November 18th 03 10:46 PM
Need to Find End Value of a Column with Unknown End Range	Tricia[_3_]	Excel Programming	2	August 24th 03 07:20 PM

All times are GMT +1. The time now is 07:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us