Thread
:
PasteValue Without Selecting
View Single Post
#
1
Posted to microsoft.public.excel.programming
William[_2_]
external usenet poster
Posts: 227
PasteValue Without Selecting
Hi Dan
sInput.Range("Y22:Y200").Value = sInput.Range("Y22:Y200").Value
--
XL2002
Regards
William
"Dan Gesshel" wrote in message
...
| Hello.
|
| I want to do a PasteValue over the same range to keep the values and wipe
| the formulas. I thought this would work:
|
| sInput.Range("Y22:Y200").Copy
| sInput.Range("Y22:Y200").PasteSpecial xlPasteValues
|
| Unfortunately, this is still selecting the cells. Is there a way to do a
| PasteValue without selecting the cells in any way? Any help would be
greatly
| appreciated.
|
| Thanks.
|
| Dan
|
|
Reply With Quote
William[_2_]
View Public Profile
Find all posts by William[_2_]