| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a cell with a special value and activate it
Hello!
I'd like to do the following: Get a date from a different workbook (which is given in cell A9) and then find the date in my workbook in Row "1" and activate the cell. Can anybody help? Thank you! Mirja |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find a cell with a special value and activate it
Dim oCell As Range Set oCell = Rows(1).Find(Range("A9").Value) If Not oCell Is Nothing Then oCell.Select End If -- HTH RP (remove nothere from the email address if mailing direct) "Mirja" wrote in message ... Hello! I'd like to do the following: Get a date from a different workbook (which is given in cell A9) and then find the date in my workbook in Row "1" and activate the cell. Can anybody help? Thank you! Mirja |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find a cell with a special value and activate it
Many thanks!!
Mirja -----Original Message----- Dim oCell As Range Set oCell = Rows(1).Find(Range("A9").Value) If Not oCell Is Nothing Then oCell.Select End If -- HTH RP (remove nothere from the email address if mailing direct) "Mirja" wrote in message ... Hello! I'd like to do the following: Get a date from a different workbook (which is given in cell A9) and then find the date in my workbook in Row "1" and activate the cell. Can anybody help? Thank you! Mirja . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find a cell with a special value and activate it
my pleasure.
-- HTH RP (remove nothere from the email address if mailing direct) "Mirja" wrote in message ... Many thanks!! Mirja -----Original Message----- Dim oCell As Range Set oCell = Rows(1).Find(Range("A9").Value) If Not oCell Is Nothing Then oCell.Select End If -- HTH RP (remove nothere from the email address if mailing direct) "Mirja" wrote in message ... Hello! I'd like to do the following: Get a date from a different workbook (which is given in cell A9) and then find the date in my workbook in Row "1" and activate the cell. Can anybody help? Thank you! Mirja . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Special Characters | Excel Worksheet Functions | |||
| find special characters | Excel Discussion (Misc queries) | |||
| How do I activate the trial exel 2003 program if it does't find c. | New Users to Excel | |||
| Find Cell Value and Activate | Excel Programming | |||
| Using a Macro to find a value in a range and activate it | Excel Programming | |||
Hybrid Mode
