Posted to microsoft.public.excel.programming

Alan Beban[_2_] Alan Beban[_2_] is offline

external usenet poster

Posts: 783

Variable type

Thanks, Chip.

Alan Beban

Chip Pearson wrote:
Alan,

The only way I can think of to test whether Rng is declared explicitly
as a Range rather than as a Variant is to attempt to set Rng to another
type of object. If this does not cause an error, then Rng is a Variant.
If it fails, Rng is declared as a Range. . . .

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
Type of variable	J@Y	Excel Programming	3	August 14th 07 04:14 PM
Variable type Confusion	D Zandveld	Excel Programming	2	March 5th 07 09:07 AM
What data type for Variable?	Jeff Armstrong	Excel Programming	4	August 6th 04 09:38 PM
type variable as argument of a sub	Koos	Excel Programming	1	October 23rd 03 11:41 AM
Variable Type - help me to solve this	choco140	Excel Programming	1	September 28th 03 10:39 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us