Select Cells in a specific Row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hilvert Scheper - 29 Apr 2008 11:49 GMT

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

Reply to this Message

Bob Phillips - 29 Apr 2008 11:55 GMT

Cells(Selection.Row, "E").Select

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Could anyone help me here please,
> VBA (I'm using Office 2003) will find a specific Cell in a spreadsheet in
[quoted text clipped - 12 lines]
> ' Here I want to Change the selection to the Same Row in Column E
> End Sub

Reply to this Message

Hilvert Scheper - 29 Apr 2008 12:20 GMT

Thank You very much indeed Bob, Brilliant!!

> Cells(Selection.Row, "E").Select
>
[quoted text clipped - 14 lines]
> > ' Here I want to Change the selection to the Same Row in Column E
> > End Sub

Reply to this Message