Store cell data in a variable

[snowing]

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

 

[Norman Jones]

Hi Snowing,

Try:

Dim myDate As Date

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