hello ,
I was recording a macro like this:
Sub Macro3()
Selection.EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
Range("E3").Select
Selection.Copy
Range("C4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("E4").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("D3").Select
Application.CutCopyMode = False
Selection.Copy
Range("C3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
what if it is using VBA code,is it possible..? because the macro is only valid for a particular cell
thanks in advance
Bookmarks