Hi! I am trying to copy a range (A1:A7) from one sheet to another. All cells in range have formulas and one cell in particular (A1) has a hyperlink. What I am trying to do is copy everything and paste it to the destination sheet except for the formulas.
I tried to use .PasteSpecial xlPasteAll but this will return an error because of the formulas. xlPasteValuesAndNumberFormats copies everything except for the hyperlink. It seems that there is nothing that lets me do exactly what I want. Any suggestions? Thanks!
I tried to use .PasteSpecial xlPasteAll but this will return an error because of the formulas. xlPasteValuesAndNumberFormats copies everything except for the hyperlink. It seems that there is nothing that lets me do exactly what I want. Any suggestions? Thanks!
