| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel macro !!
Hi all.
I want to write a macro in an excel sheet wherein I want to copy a few cells from my source worksheet and paste their link ...not teh HYPERLINK.....to another worksheet. Also, the destination worksheet's cell number where this is pasted is not fixed. How do I accomplish this? Please help urgently. Thanks. |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel macro !!
Edit=PasteSpecial
Click the Paste Link button. -- Regards, Tom Ogilvy "SPG" wrote in message ... Hi all. I want to write a macro in an excel sheet wherein I want to copy a few cells from my source worksheet and paste their link ...not teh HYPERLINK.....to another worksheet. Also, the destination worksheet's cell number where this is pasted is not fixed. How do I accomplish this? Please help urgently. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| passing variables from an excel macro to a powerpoint macro | Excel Programming | |||
Linear Mode
