Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My cell C6 contains Vaughn
Sub FindCell() With ActiveSheet.Range("B4:G9") Set c = .Find(What:="Vaughn", LookAt:=xlWhole, _ LookIn:=xlValues, SearchOrder:=xlByColumns) End With MsgBox "Subject value is in cell " & c.Address '<< error here !! End Sub |