Copy only links from cell range to another cell range

Ironman

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
1,069
Office Version
  1. 365
Platform
  1. Windows
Hi

Cell range A599:A613 contains different links that have changed.

I need to copy the links in the above range and paste the new links in cell range B599:E613 without affecting any of the contents of those cells.

I'd appreciate it if there's a way of doing this with code before I die of boredom doing it manually :-)

Many thanks!
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
You must log in or register to reply here.

Similar threads

D
  • Question Question
Automatically add cell contents of specific range to cell comments when opening a document
Replies
3
Views
160
saboh12617
S
A
  • Question Question
Hyperlink only showing cell value, rather than the link working
Replies
2
Views
242
andrewlau2881
A
F
  • Question Question
Macro to copy the format of a chosen named range to another fixed point
2
Replies
10
Views
481
DanteAmor
DanteAmor
L
  • Solved
copy cell and cell above onto different sheet, under the next available line.
Replies
5
Views
188
Alex Blakenburg
A
A
  • Question Question
Take screenshots & simultaneously capture the link, place it into an Excel file which is linked to a FileMaker/Claris db.
Replies
3
Views
396
Dan_W
D

Forum statistics

Threads
1,224,222
Messages
6,177,221
Members
452,765
Latest member
Erka Gizli

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top