FEBRUARY 18TH, 2010
By ADMIN
By ADMIN
Display sheetname in cell formula
=MID(CELL(”filename”,A1),FIND(”]”,CELL(”filename”,A1))+1,256)
Posts tagged: name
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
