Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteValue Without Selecting
With sInput.Range("Y22:Y200")
..Formula = .Value End With -- Regards, Tom Ogilvy 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SELECTING LAST ROW | Excel Discussion (Misc queries) | |||
Selecting the Same | Excel Discussion (Misc queries) | |||
Selecting | Excel Discussion (Misc queries) | |||
Selecting every odd row | Excel Discussion (Misc queries) | |||
PasteValue Without Selecting | Excel Programming |