View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stan Stan is offline
external usenet poster
 
Posts: 150
Default VB Code Question

When running the code below, I'm getting the error 'Name Argument Not Found'
and the 'LookAt:=xlPart' text is highlighted. Any ideas on what I'm doing
wrong?

Sub DateMacro1()

Range("A1:O1").Select
Selection.Replace What: InputBox ("Enter Date"), _
Replacement: InputBox ("Enter Date"), _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False, _
SearchFormat:=False, _
ReplaceFormat:=False
End Sub

Many thanks if you can help!