07-06-2008, 07:26 AM
In Excel you can record it. Use Excel's recording (menu Tools -> Macro ....). It records Excel macro, like this:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 2008.07.06 by G
'
' Keyboard Shortcut: Ctrl+y
'
ActiveCell.FormulaR1C1 = "dd"
Range("A2").Select
Columns("A:A").ColumnWidth = 34
End Sub
Excel macros can be launched from QM or converted to QM.
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 2008.07.06 by G
'
' Keyboard Shortcut: Ctrl+y
'
ActiveCell.FormulaR1C1 = "dd"
Range("A2").Select
Columns("A:A").ColumnWidth = 34
End Sub
Excel macros can be launched from QM or converted to QM.