Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro using relative references | Excel Worksheet Functions | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
macro vba relative references | Excel Worksheet Functions | |||
Making the Sheet a relative value? | Excel Worksheet Functions |