ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Strings (https://www.excelbanter.com/excel-programming/294692-strings.html)

Aaron Cooper

Strings
 
I need to a bit of code that is going to be put in a loop that will
change the relative references to absolute references. The part of do
not know how to do is that I need it to only change to absolute if it
links to a specifically named sheet. That sheet may not always be in
the same order though sometimes it could be the first tab sometimes the
5th tab, etc.

Please help me if possible.

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Tom Ogilvy

Strings
 
Looks like you got help on a later posting.

--
Regards,
Tom Ogilvy

"Aaron Cooper" wrote in message
...
I need to a bit of code that is going to be put in a loop that will
change the relative references to absolute references. The part of do
not know how to do is that I need it to only change to absolute if it
links to a specifically named sheet. That sheet may not always be in
the same order though sometimes it could be the first tab sometimes the
5th tab, etc.

Please help me if possible.

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!





All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com