Thread: Selecting after Find Method
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
  
Posts: 486
Default Selecting after Find Method
C.Entirerow.Select
--
HTH...

Jim Thomlinson


"Kou Vang" wrote:

How do I select the entire row of C after I find and select it? Thanks

Set C = .Find("Date", LookIn:=xlValues)
If C Is Nothing Then
MsgBox "Not Found!"
Else
C.Select



Reply With QuoteReply With Quote