ExcelBanter - How to assign Time and Date into cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to assign Time and Date into cell? (https://www.excelbanter.com/excel-worksheet-functions/177381-how-assign-time-date-into-cell.html)

Eric

How to assign Time and Date into cell?

mycell.offset(0,1).value = Time
mycell.offset(0,1).value = Date

Does anyone have any suggestions on how to assign Time and Date into cell?
Thanks in advance for any suggestions
Eric

Mike H

How to assign Time and Date into cell?

MyCell.Offset(0, 1).Value = Now

Mike

"Eric" wrote:

mycell.offset(0,1).value = Time
mycell.offset(0,1).value = Date

Does anyone have any suggestions on how to assign Time and Date into cell?
Thanks in advance for any suggestions
Eric

Dave Peterson

How to assign Time and Date into cell?

Check your other thread, too.

Eric wrote:

mycell.offset(0,1).value = Time
mycell.offset(0,1).value = Date

Does anyone have any suggestions on how to assign Time and Date into cell?
Thanks in advance for any suggestions
Eric

--

Dave Peterson

All times are GMT +1. The time now is 04:22 AM.