Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieving data from Excel and store it into string variable | Excel Programming | |||
Retrieving data from Excel and store it into string variable | Excel Programming | |||
Retrieving data from Excel and store it into string variable | Excel Programming | |||
Retrieving data from Excel and store it into string variable | Excel Programming | |||
Retrieving data from Excel and store it into string variable | Excel Programming |