View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TKS_Mark TKS_Mark is offline
external usenet poster
 
Posts: 68
Default Macro on Current Row

I want to macro below to work on the current row instead of row 3. Please
help.

Selection.Copy
Range("F3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("F3:G3").Select
Selection.Replace What:="=", Replacement:="=", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False