Short VB code for PasteValue

  • Thread starter Thread starter slc
  • Start date Start date
S

slc

Hi,

I have these 2 lines of code which I hope to shorten it to 1 line.
Anyone have any idea how to do it?

Basically, I want to convert the formula in A1 to A3 to its value. In
the nutshell, I do a copy in range A1:A3 and then do a "Paste Special"
with values only.

Thanks for your help.

...start...
Range("A1:A3").Copy
Range("A1:A3").PasteSpecial Paste:=xlPasteValues
...end...
 
Sorry. I wasn't paying attention to the 2 lines to 1 part of you
question.

I have never found a way to do this with one line
 
Paul & Rado,

Thanks for your help. This 1-liner works fine for me.

...start...
Range("A1:A3").Value=Range("A1:A3").Value
...end..
 
Back
Top