View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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