Store cell data in a variable

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,

Hi Snowing,

Try:

Dim myDate As Date

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


---
Regards,
Norman



"snowing" <snowing.28j45n_1148838901.5156@excelforum-nospam.com> wrote in
message news:snowing.28j45n_1148838901.5156@excelforum-nospam.com...
>
> 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
>