Better way for xlPasteValues?

[Groves22]

I was just wondering if there was a better way to paste values.

What I have now is:

        .Range("AH140:AH165").Copy
        .Range("AH140:AH165").PasteSpecial xlPasteValues

I tried:

        .Range("AH140:AH165").Copy .Range("AH140:AH165").PasteSpecial xlPasteValues

But it didn't work.

Thanks

 

[SkipVought]

Hi,

Is there a problem with your original method?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlbo]

nope - 2 commands is how you have to do it

Your trial will fail as the COPY method will only do a full paste using the optional "destination" argument

The only other option, depending on your requirements would be to use something like

.Range("AH140:AH165").value = .Range("AH140:AH165").value

- I assume this is an effort to remove formulae.....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[PHV]

What about something like this ?
.Range("AH140:AH165").Value = .Range("AH140:AH165").Value

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Groves22]

I guess not, but it still makes the screen flash to the page/cells.

I guess if there isn't a good way, ScreenUpdating should solve the problem.

 

[Groves22]

Thanks xlbo and PHV...
That seemed to work great!