View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grasshopper Grasshopper is offline
external usenet poster
 
Posts: 6
Default Move of Sheet screws up Stored Sheets

When I add a workbook I get only 1 sheet, not sure why it's not 3, but
nonetheless there's the 1. I use the Item( 1 ) method to get the pointer of
the worksheet. I store it for future use. If I add a worksheet, I store the
pointer as well. All is fine. Item, Index, Name both work fine and I can
select between the two without problems. If I do a Move of a sheet then a
call to get the Name, Item, Index properties fails. Any ideas? Thanks.
-G-