Posted to microsoft.public.excel.programming
|
|
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
|