Memory In Excel?

On Sat, 25 Jun 2005 at 16:11:59, TrippinAnts22 (TrippinAnts22
<[email protected]>) wrote:
>Or, is it possible to take the date, and convert it somehow to a
>number, and say if column A is less than column B,copy column B to
>column A? if so could someone explain that as well. Thank you.
>
Dates are actually held as numbers - relative to the 1st Jan 1970 IIRC.
The decimal part then represents the time. Just assigning your date
variable to an integer variable should do the trick
--
Mike

thanks, but how in a formula do you write something that says:


if date is less than another date, copy?
iknow the if statements, but how do you make it copy?

On Sat, 25 Jun 2005 at 23:32:34, TrippinAnts22 (TrippinAnts22
<[email protected]>) wrote:
>
>thanks, but how in a formula do you write something that says:
>
>
>if date is less than another date, copy?
>iknow the if statements, but how do you make it copy?
>
>
Sorry you need to do this in visual basic

e.g. WorkSheets("Sheet1").Cells(1,1) = WorkSheets("Sheet2").Cells(1,1)


I do some share manipulation where my shares spreadsheet opens another
workbook, then I prefix WorkSheets with something like
WorkBooks("Prices") - Prices being the name of the XLS file containing
the new share data
--
Mike

sorry, so one more question with this, i use what you said in VBA, but just doing that, it woudlnt work. To actually have it have the if statements, can you explain to me what i do? Ihave used vba a few times, but not too much to be able towrite scripts on my own.

THank you,

Ben