View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
J Sedoff comRemove> J Sedoff comRemove> is offline
external usenet poster
 
Posts: 42
Default help! subscript out of range error when trying to return multiple

You could also just change the code to this:
IntermediateArray(1, 7) = ConversionData(1, 1)
IntermediateArray(1, 8) = ConversionData(2, 1)
IntermediateArray(1, 9) = ConversionData(3, 1)

Since you transposed it, it becomes a 2D array, rather than just 1D, so you
need to include the 2nd dimension (the ",1)" ).

Hope this helps, albeit a little late! Jim
--
I appreciate any feedback.