Posted to microsoft.public.excel.programming

Jan Karel Pieterse Jan Karel Pieterse is offline

external usenet poster

Posts: 535

passing targets between functions

Hi Bob,

That is not right. Just change

clearAround (target)

to

clearAround target

Of course! (target) gives you the value(s) of the default property, the
value of the cell(s), which of course fails when the called sub expects
a range object

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
passing arrays to user defined functions	ramki	Excel Worksheet Functions	2	February 15th 06 08:34 AM
General Question regarding passing cells, ranges, cell values through subs & functions	[email protected]	Excel Programming	1	September 5th 04 06:46 PM
passing arrays between functions in VBA	Tom Ogilvy	Excel Programming	3	March 1st 04 05:54 PM
Passing parameters between functions	Gaston[_7_]	Excel Programming	4	February 9th 04 04:08 AM
Passing Parameters to Userdefined Functions	Peter M[_3_]	Excel Programming	3	December 13th 03 07:56 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us