| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Copy Link | Excel Discussion (Misc queries) | |||
| copy link | Excel Discussion (Misc queries) | |||
| Link Value Update during COPY | Excel Discussion (Misc queries) | |||
| copy link from next worksheet | Excel Worksheet Functions | |||
| Past Link then copy | Excel Discussion (Misc queries) | |||
Linear Mode
