G Guest Dec 27, 2003 #1 Is there a function which return the address or contents of the current active cell?
D Dave Peterson Dec 27, 2003 #2 msgbox activecell.address msgbox activecell.value msgbox activecell.text Would give the addres, the value and what's shown in the cell.
msgbox activecell.address msgbox activecell.value msgbox activecell.text Would give the addres, the value and what's shown in the cell.