Posted to microsoft.public.excel.misc

Caeres

external usenet poster

Posts: 15

How do I return the location (as a range) of ActiveCell?

I need the reference to a range to be dynamic, based on the ActiveCell. How
can I return the range of the ActiveCell so that I can use it in operations
requiring a Range as an argument?

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
ACTIVECELL LOCATION	kt(uk)	Excel Discussion (Misc queries)	2	September 12th 08 01:03 PM
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Excel Discussion (Misc queries)	1	October 2nd 07 08:05 PM
ActiveCell in a Range?	Filo	Excel Discussion (Misc queries)	3	May 22nd 07 09:52 PM
Activecell, not for cell,but for range?	mturner	Excel Discussion (Misc queries)	1	January 24th 06 04:55 PM
ActiveCell.Copy Range("R3C27")	Stuart Grant	New Users to Excel	2	September 30th 05 09:00 AM

All times are GMT +1. The time now is 10:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us