Range ID not saved
Hello,
I set the Range.ID property to some string value then I save and close the workbook but when I reopen it the ID is empty. Is this a normal behaviour or at least avoidable, or is there other way to keep some IDs to cells/ranges persistently after the workbook is closed. Thanks for your time, Nacho |
Range ID not saved
Hi Nacho,
This is normal behaviour: range.ID is not saved with the workbook. You can store information persistently in Defined Names. Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "Nacho Nachev" wrote in message ... Hello, I set the Range.ID property to some string value then I save and close the workbook but when I reopen it the ID is empty. Is this a normal behaviour or at least avoidable, or is there other way to keep some IDs to cells/ranges persistently after the workbook is closed. Thanks for your time, Nacho |
Range ID not saved
afaik the Range.ID is used only for webpages.
and only SAVED when the workbook is saved as a web page. Normal files could use Range Name for identification purposes. (although I realise it's NOT the same :) keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Nacho Nachev" wrote: Hello, I set the Range.ID property to some string value then I save and close the workbook but when I reopen it the ID is empty. Is this a normal behaviour or at least avoidable, or is there other way to keep some IDs to cells/ranges persistently after the workbook is closed. Thanks for your time, Nacho |
Range ID not saved
Thanks, guys!
"Nacho Nachev" wrote in message ... Hello, I set the Range.ID property to some string value then I save and close the workbook but when I reopen it the ID is empty. Is this a normal behaviour or at least avoidable, or is there other way to keep some IDs to cells/ranges persistently after the workbook is closed. Thanks for your time, Nacho |
All times are GMT +1. The time now is 05:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com