Thread
:
Select Cells in a specific Row
View Single Post
#
3
Posted to microsoft.public.excel.programming
Hilvert Scheper
external usenet poster
Posts: 31
Select Cells in a specific Row
Thank You very much indeed Bob, Brilliant!!
"Bob Phillips" wrote:
Cells(Selection.Row, "E").Select
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Hilvert Scheper" <Hilvert
wrote in
message ...
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 With Quote
Hilvert Scheper
View Public Profile
Find all posts by Hilvert Scheper