Posted to microsoft.public.excel.programming

Emile[_2_] Emile[_2_] is offline

external usenet poster

Posts: 4

Range selection for macro

I would like to select a range of cells using my mouse and then start a
macro based on the selected range.

How do I code the macro to use the mouse selected range for the SUMIF
functions that followin the macro?

The range would be not be the same every time. The SUMIF function would be
the same for any selected range.

Thanks in advance for your help

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
How to get users' range selection in VBA macro?	Samuel Wu	Excel Programming	2	December 1st 06 06:10 PM
Macro to change list box input range based on selection made in another cell	Sue[_6_]	Excel Programming	3	October 7th 04 06:45 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 07:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us