LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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-
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Editting xml format sheets stored in database. Martyn Excel Discussion (Misc queries) 0 April 1st 08 02:22 AM
move cursor on one sheet moves cursor on all sheets tdworden Excel Discussion (Misc queries) 2 July 22nd 07 10:50 PM
Is this a joke or Microsoft screws up again? John Smith Excel Discussion (Misc queries) 0 December 19th 06 02:34 AM
referencing to a sheet that it`s name is stored on a cell [email protected] Excel Worksheet Functions 7 November 27th 06 05:59 PM
Getting data from sheet stored on LAN [email protected] Excel Programming 3 December 11th 04 01:07 AM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"