MAcro current time and date

[akpengg]

i want code for Macro which give u current timestamp in column 3

i am getting file name in clm B from one folder and want to leave clm a blank.

 

[Luke M]

Something like:

[pre]

Range("C2").Value = Now

[/pre]

 

[akpengg]

give me ur email i will send u detail

 

[Luke M]

Sorry, but I don't post my email. Gives me the freedom to operate here on a volunteer basis. =)


If you'd like, see the 2n stickey at top of forums to see how to upload a workbook. Please note that you've only given us 2 sentences saying what you want. Elaborating greatly on what you have vs. what you want would help us find a better solution.