View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vicky vicky is offline
external usenet poster
 
Posts: 52
Default how to store values in a 2 dimensional array

i want to store Sheet name and its corresponding password in a 2
dimension array . hope anyone can provide a code snippet for storing
sheet name and its corresponding password and also code for popping
out values from an array . i am newbie to vba . providin code wil be
really helpful . i need something like

i need to store the values in this fashion

Array(0) ----- should contain sheetname and its password value
Array(1) ----- should contain sheetname and its password value

while popping out i shuld put the values in 2 variables .

sheet name in Variable 1 its corresponding password in
Password in Variable 2 ................

hope anyone can provide a code for this ........