View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hilvert Scheper[_2_] Hilvert Scheper[_2_] is offline
external usenet poster
 
Posts: 2
Default Select Cells in a specific Row

Could anyone help me here please,
VBA (I'm using Office 2003) will find a specific Cell in a spreadsheet in
Column C, and I then want to Change the Selection to the Same row in Column E.
Any ideas are welcome, Many thanks!

Here's the code I use:

Columns("C:C").Select
Selection.Find(What:="NO", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Select
' Here I want to Change the selection to the Same Row in Column E
End Sub