Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Copy and Paste
I am trying to copy the text from one cell to another without
overwriting the Hyperlink in the second cell. Example A1 = Chapter 4 B1=\\My Documents\Chapter4.txt A1 is text and B1 is a link to the TXT file. I want B1 to = Chapper 4 but still keep the hyperlink of \\My Documents\Chapter4.txt I can do this by selecting the first cell, hitting F2, highlighting the text for that cell and coping it. Then I have to select the second cell, hitting F2, highlight the text in that cell and pasting the new text. This keeps the original hyperlink of the second cell intact. And while this works for a changing a limited number of cells, I have to do this for 3,000 records. And I have been unable to create a macro that will do it for me. Any suggestions? Thanks Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Copy and Paste
Hi try,
Sub yourmacro() Dim i As Integer For i = Range("a65536").End(xlUp).Row To 1 Step -1 Cells(i, 2).Value = Cells(i, 2) & Cells(i, 1) Next End Sub "Smonczka" wrote in message oups.com... I am trying to copy the text from one cell to another without overwriting the Hyperlink in the second cell. Example A1 = "Chapter 4" B1="\\My Documents\Chapter4.txt" A1 is text and B1 is a link to the TXT file. I want B1 to = "Chapper 4" but still keep the hyperlink of "\\My Documents\Chapter4.txt" I can do this by selecting the first cell, hitting F2, highlighting the text for that cell and coping it. Then I have to select the second cell, hitting F2, highlight the text in that cell and pasting the new text. This keeps the original hyperlink of the second cell intact. And while this works for a changing a limited number of cells, I have to do this for 3,000 records. And I have been unable to create a macro that will do it for me. Any suggestions? Thanks ? Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Copy and Paste
Thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Macro to Copy/Paste then Paste to Next Line | Excel Programming |