Hi there,

Please consider registering for an account. Registration is free, only takes a minute and will allow you to access members only boards. If you already have an account with us, then click here to log in.

collapse

* Who's Online

  • Dot Guests: 21
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.


Author Topic: Mark current date and time in a specific cell. (VBA)  (Read 3341 times)

0 Members and 1 Guest are viewing this topic.

WestwegoManTopic starter

  • Administrator
  • Pirogue Pusher
  • *****
  • Posts: 46
  • Age: 50
  • Location: Westwego, La.
    • View Profile
This macro will mark the current time from the PC into cell "I2"

Code: [Select]
Workbooks("Test.xls").Sheets("Main").Cells(2, "I") = Date & "  " & Time


 


The postings on this site are my own and do not necessarily reflect the views of Jefferson Parish,

fellow employees, members of the public, suppliers or people working on behalf of the parish.


SimplePortal 2.3.6 © 2008-2014, SimplePortal