View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian Digby[_3_] Ian Digby[_3_] is offline
external usenet poster
 
Posts: 15
Default Selecting after Find Method

Kou Vang,

Use

C.EntireRow.Select

Regards
Ian
--
Work performed in the spirit of service is worship...Baha''''i Writings


"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