ExcelChampion
Well-known Member
- Joined
- Aug 12, 2005
- Messages
- 976
Never ran into this before...guess it just never came up.
So, I have a simple VBA array:
vars = Range("G2:G" & Cells(Rows.Count, 7).End(xlUp).Row).Value
where vars is DIM'd as a variant: Dim vars() as Variant
Problem is, when the array turns out to be one cell, it craps out...type mismatch. What's a workaround?
Thanks.
So, I have a simple VBA array:
vars = Range("G2:G" & Cells(Rows.Count, 7).End(xlUp).Row).Value
where vars is DIM'd as a variant: Dim vars() as Variant
Problem is, when the array turns out to be one cell, it craps out...type mismatch. What's a workaround?
Thanks.