I have a macro that copies data from a temp worksheet and pastes it to my main workbook my only issue when the data is pasted to my main workbook the hyperlinks are not there. The temp sheet has numbers that hyperlinks are attached to. Here is my macro. Is there a way for the hyperlinks to get pasted with the numbers as well.
Selection.Copy
ThisWorkbook.Worksheets("LastMile").Range("A3").End(xlDown).Offset(1, 0).PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
ActiveWindow.Close SaveChanges:=False
ActiveWindow.WindowState = xlMaximized
the number below would have a hyperlink attached to it
Selection.Copy
ThisWorkbook.Worksheets("LastMile").Range("A3").End(xlDown).Offset(1, 0).PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
ActiveWindow.Close SaveChanges:=False
ActiveWindow.WindowState = xlMaximized
the number below would have a hyperlink attached to it
1004510076279039302501960200701 |