Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Group,
I am having trouble with the follwing. When I try and find, it says it is not set. Dim SerialNumber As String Set SerialNumber = ActiveCell.Offset(1, 3).Value & ActiveCell.Offset(1, 4).Value Selection.Find(What:=SerialNumber, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate I tried the last statement with the Variable SerialNumber in ( ), but it still says it is not set. Thanks -- David |