Cells.Find

[Mike R.]

Is there a way to use a string variable as a parameter for
the Cells.Find function when using VBA for Excel. For
example, given:

Function PrintCustomerMessageCell(CMessage As String)

'Place focus on the cell that contains this data
Cells.Find(CustomerMessage).Activate
'I get an error in the line above.

'Tell me what cell it is
MsgBox ActiveCell.AddressLocal(RowAbsolute:=False,
ColumnAbsolute:=False)


End Function


Thank you...

 

[Tom Ogilvy]

PrintCustomerMessageCell - name of function
CMessage - string passed into function
CustomerMessage - undefined uninitialized variable that contains no value to
search for

Yes, find can search for a string argument.

 

[Mike R.]

I found a mispelled word that I was passing to my function
as a string which made the function fail. Thank you..