Store cell data in a variable
 

Hello,

Does anyone know how to retrieve the value from a cell and store it i
a variable ?

What I want to do is, create a loop to look at the data in each cell i
row "C"
I want it to take that data in the first row of column "C" (which woul
be a date) and store it in a variable to use later or compare it wit
some other variable.

Thanks

--
snowin
-----------------------------------------------------------------------
snowing's Profile: http://www.excelforum.com/member.php...fo&userid=3457
View this thread: http://www.excelforum.com/showthread.php?threadid=54629

Store cell data in a variable
 

Hi Snowing,

Try:

Dim myDate As Date

myDate = Cells(1, "C").Value


---
Regards,
Norman



"snowing" wrote in
message ...

Hello,

Does anyone know how to retrieve the value from a cell and store it in
a variable ?

What I want to do is, create a loop to look at the data in each cell in
row "C"
I want it to take that data in the first row of column "C" (which would
be a date) and store it in a variable to use later or compare it with
some other variable.

Thanks,


--
snowing
------------------------------------------------------------------------
snowing's Profile:
http://www.excelforum.com/member.php...o&userid=34576
View this thread: http://www.excelforum.com/showthread...hreadid=546294