Thread: Range Replace
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rewop Eilsel[_2_] Rewop Eilsel[_2_] is offline
external usenet poster
 
Posts: 8
Default Range Replace

The following macro works well as two seperate halves but fails when joined
together
Range(ActiveCell, ActiveCell.Offset(2, 0)).Select
Selection.EntireRow.Select.Replace What:=Range("AB28"), _
Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

The first half works, but the second half (from "Replace...") comes back
with the comment "Run Time Error 424" & " Object required", can anyone please
help?

Rewop Eilsel