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 |
Select Cells in a specific Row
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 |
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 |
All times are GMT +1. The time now is 09:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com