Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select specific cells to be my tab stops? | Excel Worksheet Functions | |||
How to select cells in specific Columns? | Excel Programming | |||
select cells that sum up to a specific value | Excel Discussion (Misc queries) | |||
macro to select cells containing specific text and delete all cells but these | Excel Programming | |||
How do I select specific excel cells to use tab key for? | Excel Programming |