JUNE 30TH, 2009
By ADMIN
By ADMIN
Use a ‘check’ symbol in Excel
Set font to Wingdings, and use ALT+0252..
So simple, but took me a while to get it 
Posts tagged: use
APRIL 9TH, 2009
By ADMIN
By ADMIN
Use a defined name in your macro
I want my vba macro to refer to a name I defined in a worksheet within the current workbook:
'Define y as the value of a cell you have named NAME..
Application.GoTo Reference:="NAME"
y = ActiveCell.Value
Application.GoTo Reference:="NAME"
y = ActiveCell.Value
'Define y as the row of a cell you have named NAME..
Application.GoTo Reference:="NAME"
y = ActiveCell.Row
'Define y as the column of a cell you have named NAME..
Application.GoTo Reference:="NAME"
y = ActiveCell.Column
