Address of current cell

[Jalaluddin]

Hi,

I want to know if i can get the address of the cell at
which the cursor is currently positioned.

This is usually displayed at the top left hand corner of
the worksheet.

Based on the current cell address i want to display a
message and therefore i want to know how to put the 'if
condition'

for example if the current cell is A5 i want do
display 'Sales' or if the current cell is B5 i want to
display 'Net Profit %'

 

[Andy Wiggins]

In VBA it's:

ActiveCell.Address

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "The Excel Auditor" and "Byg Tools for VBA"