Posted to microsoft.public.excel.programming

GerryM[_2_] GerryM[_2_] is offline

external usenet poster

Posts: 2

Selecting & Pasting Dynamic Ranges

I have a sheet with 10000 rows but this can vary. Columns
A to C always have text in all rows. I want to paste a
value from Row 2 column A to all rows in Column D. As the
number of rows can vary how can I do this with a macro
with having to manually tell it how many rows there are.

GerryM

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
Dynamic Formulas with Dynamic Ranges	Ralph Howarth	Excel Worksheet Functions	5	January 21st 05 08:44 AM
Selecting ranges	Steve Wood	Excel Programming	1	August 24th 04 02:16 PM
Selecting and pasting to an empty cell	Craig from MI	Excel Programming	1	March 7th 04 06:36 AM
Help - Selecting and pasting into range	amonymous	Excel Programming	4	January 21st 04 12:21 AM
selecting ranges	MDC	Excel Programming	1	July 24th 03 03:34 PM

All times are GMT +1. The time now is 03:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us