myVar = Range("B2").Value

as an example

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SWT" wrote in message
oups.com...
Can Visual Basic get information from a cell and then use that as a
variable?

I have a cell that changes using the function counta. The number in
the Counta formula will change from day to day. I would like to use
that number as a variable in a macro.

Does anyone have any VBA code that shows how this could be done?

SWT