copy a link from one col to another via a formula
I have 25 worksheets in 1 book, 24 are accounts and 1 summary(sorted) with
links back to the accounts. I need to be able to retrieve the account link and be able to post back to the account data from the summary. Can this be done. |
copy a link from one col to another via a formula
If it is like
=sheet1!A1 you can do sform = ActiveCell.Formula set rng = Range(mid(sForm,2)) msgbox rng.Address(external:=True) -- Regards, Tom Ogilvy "Confused" wrote in message ... I have 25 worksheets in 1 book, 24 are accounts and 1 summary(sorted) with links back to the accounts. I need to be able to retrieve the account link and be able to post back to the account data from the summary. Can this be done. |
All times are GMT +1. The time now is 01:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com