Transpond text to public statement
I assume nCS is a named range referring to one cell? try it this way:
Cells.Find(Range(myDayNr).Value, After:=ActiveCell, LookIn:=xlValues,
LookAt:=xlWhole, _
SearchOrder:=xlRow, SearchDirection:=xlNext).Activate
--
Hope that helps.
Vergel Adriano
"KentAE" wrote:
Hi
In follwing code myGate = CS and the statement nCs =39445. In the Find
method I want that myDayNr = 39445, not "nCS". How to do?
Public nCS As Long
Sub X()
'----
myDayNr = "n" & myGate
'----
Cells.Find(myDayNr, After:=ActiveCell, LookIn:=xlValues,
LookAt:=xlWhole, _
SearchOrder:=xlRow, SearchDirection:=xlNext).Activate
End Sub
--
Officebyggaren
Kent Älmegran
|