Posted to microsoft.public.excel.programming

Dave Peterson Dave Peterson is offline

external usenet poster

Posts: 35,218

Macro Range Selection

I bet you meant

intersect(activecell.entirerow, range("a:c"))

Mike H wrote:

maybe

Union(ActiveCell.EntireRow, Range("A:C")).Select

Mike

"Roy A." wrote:

Range("A16:C16").Select

I would like the above command to select columns A:C with the current cursor
row.

Obviously a Macro newbee, lol Thanks for any assistance.

--

Dave Peterson

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
Sumeif macro with range selection	orquidea	Excel Discussion (Misc queries)	14	August 29th 08 03:12 AM
Macro Range Selection	Roy A.[_2_]	Excel Discussion (Misc queries)	3	March 16th 08 04:38 PM
Range selection for macro	Emile[_2_]	Excel Programming	3	April 27th 07 05:43 PM
How to get users' range selection in VBA macro?	Samuel Wu	Excel Programming	2	December 1st 06 06:10 PM
Range selection code in a macro	Floss	Excel Programming	1	December 30th 03 01:05 AM

All times are GMT +1. The time now is 01:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us