Consulting

Results 1 to 3 of 3

Thread: Solved: How to check the type of an array

  1. 06-29-2008, 08:40 PM #1
    Emily
    Emily is offline
    VBAX Contributor
    Joined
    Oct 2004
    Posts
    159
    Location

    Solved: How to check the type of an array

    This page can find the type of variables, from which array can be identified.

    I want to get the type of an array.

    Thanks
    Reply With Quote Reply With Quote
  2. 06-29-2008, 08:47 PM #2
    mikerickson
    mikerickson is offline
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    [VBA]MsgBox TypeName(myArray)[/VBA]
    Reply With Quote Reply With Quote
  3. 06-29-2008, 08:55 PM #3
    Emily
    Emily is offline
    VBAX Contributor
    Joined
    Oct 2004
    Posts
    159
    Location
    Oh, that's simple

    Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules