Ask Your Question

Revision history [back]

You can get the cell address by using the property
oSel.AbsoluteName
To see all the properties of oSel use
MsgBox oSel.dbg_properties
and to see all the methods that can be applied to oSel use
MsgBox oSel.dbg_methods
You can use these calls on any Object that is visible in a Macro.

You can change the data in the Cell by using
oSel.Value = the new value

You can get the cell address by using the property
oSel.AbsoluteName
To see all the properties of oSel use
MsgBox oSel.dbg_properties
and to see all the methods that can be applied to oSel use
MsgBox oSel.dbg_methods
You can use these calls on any Object that is visible in a Macro.