View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default 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