using macro to insert non-dymanic time and date / seperate columns

How do I get a macro to insert the date and time into
two seperate cells. When the macro is run it will get the current date and time and log it in a cell.
The now() is a dynamic value which changes. I only want the actual date and time the macro is run.

Any help would be appericated.