Active Cell function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a function which return the address or contents of the current active cell?
 
msgbox activecell.address
msgbox activecell.value
msgbox activecell.text

Would give the addres, the value and what's shown in the cell.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use of ADDRESS function within CELL function 4
how do I create a cell reference from ADDRESS function return? 3
Creating a reader bar with Conditional Formatting 1
Find address of active cell 5
Can UDF return a customized hyperlink? 3
Excel code, end function? 0
Active Cell Color 5
XL2000 Array Function Problem 2

Back
Top