View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
S G Booth S G Booth is offline
external usenet poster
 
Posts: 20
Default Load an array with Sheet names

varr is a Variant array. I wish to load it with names of sheets in the
activeworkbook.
I have:

If Global_PrintAllBooks_Sheets = True Then
ReDim varr(1 To Worksheets.Count)
For i = 1 To UBound(varr)
varr(i) = ws.Name
i = i + 1
Next

I receive run time error 91 (Object variable or With block variable not set)
on varr(i) = ws.Name

Why is this please?

Regards.