View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_5_] Stuart[_5_] is offline
external usenet poster
 
Posts: 413
Default Type mismatch error

With Select_Worksheets.ListBox1
iCtr1 = 0
For iCtr = 0 To .ListCount - 1
iCtr1 = iCtr1 + 1
ReDim Preserve varr(1 To iCtr1) ****
varr(iCtr1) = .List(iCtr)
Next iCtr
End With

Why might the line **** suddenly have started to
give a Type mismatch error, please?

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/2003