Prev: vlookup with if statement?
Next: How to save a cube pivot as an offline dataset?
From: KennyD on 2 Feb 2010 13:44
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.
 | 
Pages: 1
Prev: vlookup with if statement?
Next: How to save a cube pivot as an offline dataset?