View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default Reference named range in closed workbook

sorry i forgot to declare

Dim i As Integer, n As Integer, rw As Long
Dim sSheetName As ADOX.Table

isabelle