View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
S.V.Proff S.V.Proff is offline
external usenet poster
 
Posts: 1
Default Making a macro references relative

Hello All:

I have been away from using Macros for some time and I am finding that
I have forgotten how to make refereces to cells relative in a macro.

On top of this, I discovered I do not have help files...

I have the following:

Sub k()
'
' k Macro
'

'
ActiveSheet.Paste
Range("V245:AF245").Select
Application.CutCopyMode = False
Selection.Copy
Range("I243").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
End Sub

How do I make references relative to the current cell the cursor is
in?

Thanks!

Sam
(Please post your replies here. My e-mail address is spam proofed.)