aoc
06-25-2009, 02:12 PM
Hi,
how can I revise below code when I click a cell date will write and " osman " will write next to date cell. ( like A1 B1 )
Sub Macro1()
ActiveCell.FormulaR1C1 = "=TODAY()"
ActiveCell.FormulaR1C1 = "osman"
how can I revise below code when I click a cell date will write and " osman " will write next to date cell. ( like A1 B1 )
Sub Macro1()
ActiveCell.FormulaR1C1 = "=TODAY()"
ActiveCell.FormulaR1C1 = "osman"