Posted to microsoft.public.excel.programming

Eric[_6_]

external usenet poster

Posts: 23

How to specify a range in Excel macro

Hi,

How could I select a range in macro if I don't know how
many columns I have, meaning my columns is variable.

Example: Range("A1:A4").select

Need help.

TIA
Eric

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
Need help writing Excel macro when range changes	AT	Excel Worksheet Functions	1	December 13th 07 03:09 AM
macro to copy from excel range to word doc	mopgcw	Excel Discussion (Misc queries)	1	August 20th 07 07:54 PM
Help with Dynamically changing Range in Excel Macro	runsrealfast	Excel Discussion (Misc queries)	4	July 16th 07 10:44 PM
How do I set up a formula with a changing range in an excel macro	cinvic	Excel Discussion (Misc queries)	2	April 4th 06 10:39 PM
Using a macro to set a range name in EXCEL	Eric Tepen	Excel Programming	2	January 25th 04 02:19 AM

All times are GMT +1. The time now is 12:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us