Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default multidimensional array

How do I declare a multidemensional array that has both strings and integers
in it?
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 783
Default multidimensional array

ranswert wrote:
How do I declare a multidemensional array that has both strings and integers
in it?
Thanks

Either Dim myArray or Dim myArray(), depending on whether you want a
variant variable to contain an array, or a true array.

Alan Beban
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,441
Default multidimensional array

Dim myArr(1 To 10, 1 To 2) As Variant

OR use two arrays

Dim myIntArr(1 To 10) As Integer
Dim myStrArr(1 To 10) As String

HTH,
Bernie
MS Excel MVP


"ranswert" wrote in message
...
How do I declare a multidemensional array that has both strings and
integers
in it?
Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
multidimensional array Peter[_61_] Excel Programming 1 August 30th 07 05:34 PM
Multidimensional array - lookup Jason Morin Excel Programming 5 September 27th 06 06:49 PM
Syntax for multidimensional array Arne Hegefors Excel Programming 1 August 22nd 06 06:19 PM
Multidimensional Array DavidMoeller Excel Programming 4 August 12th 04 08:12 PM
MAX of Multidimensional Array ZZZ Excel Programming 2 November 15th 03 03:32 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"