The function of a macro is:
Enter the current date in cell Ax (any cell on row x may be selected),
and enter the current time in cell Bx.
I have the following lines in the macro for filling the time:
Dim c As Range
' cell selected as variable
Set c = Selection
c = Hour(Now()) & ":" & Minute(Now())
' copy value of c also into cell H3
H3 = c
End Sub
My knowledge of macros is very limited; can you advise a good book?
Thanks
Paul
Enter the current date in cell Ax (any cell on row x may be selected),
and enter the current time in cell Bx.
I have the following lines in the macro for filling the time:
Dim c As Range
' cell selected as variable
Set c = Selection
c = Hour(Now()) & ":" & Minute(Now())
' copy value of c also into cell H3
H3 = c
End Sub
My knowledge of macros is very limited; can you advise a good book?
Thanks
Paul