Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2

VBA: How can I check if an array is declaired with a dimension?

Hi!
In VBA, how can I check if an array is declaired with a dimension?

Example:

Dim MyArray() As String

No one of the following works:

IsEmpty(MyArray) Then

Not IsNull(MyArray) Then

MyArray Is Nothing Then

Best regards
M Shafaat

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
Sorting 3 columns in a 2 dimension array	John[_124_]	Excel Programming	3	November 11th 06 12:57 AM
Mutli-dimensional Array to Single-Dimension Array	Blue Aardvark	Excel Programming	3	October 15th 05 09:22 AM
Array transfer - 1 dimension v. 2 dimension	JWolf[_2_]	Excel Programming	2	June 29th 04 01:02 AM
Getting excel array dimension	banavas[_3_]	Excel Programming	3	June 8th 04 12:11 PM
single dimension array	RobcPettit	Excel Programming	3	January 20th 04 08:33 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us