| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to paste hyperlinks
Hey ya'll,
Real quick one, hopefully. :) In the below code, if I wanted to paste the values (shown), and then the formats and hyperlinks, what would I need to add? Would I add '.Cells.PasteSpecial xlFormats' and '.Cells.PasteSpecial xlHyperlinks'? If sh.Visible = -1 Then sh.Select With sh.UsedRange .Cells.Copy .Cells.PasteSpecial xlPasteValues .Cells.Select End With Application.CutCopyMode = False End If Range("A1").Activate -- Nothing in life is ever easy - just get used to that fact. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste the hyperlinks | Excel Discussion (Misc queries) | |||
| Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
| Copy text hyperlinks and paste them as source addresses? | Excel Discussion (Misc queries) | |||
| Copy/Paste hyperlinks between workbooks | Excel Discussion (Misc queries) | |||
| Copy & paste from Word to Excel with hyperlinks | Excel Discussion (Misc queries) | |||
Threaded Mode
