new to macro editing: how to force the selected cell?

I'm new to editing macros, so please bear with me if this is a basic question.

I'm trying to write a macro to create a keyboard shortcut for
Paste Special > Values

Heres' the recorded macro:

Sub PASTE_SPECIAL_VALUES()
'
' PASTE_SPECIAL_VALUES Macro
' Macro recorded 6/26/2008 by LKB
'
' Keyboard Shortcut: Ctrl+Shift+V
'
Range("D24").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

The problem is it ALWAYS puts the value in cell D24. What do I put in there to tell it the range is the selected cell(s)?

Thanks!

Originally Posted by lkb3

I'm new to editing macros, so please bear with me if this is a basic question.

I'm trying to write a macro to create a keyboard shortcut for
Paste Special > Values

Heres' the recorded macro:


The problem is it ALWAYS puts the value in cell D24. What do I put in there to tell it the range is the selected cell(s)?

Thanks!

That was easy - it needs to be
With Selection.PasteSpecial....