Is there a shortcut in excel which returns the cell co-ordinates?

[Braznor]

...or can any third party program accomplish this?

 

[mayest]

What do you mean by coordinates? If you mean the mouse pointer location, then no. You can do it in VBA, though.

 

[corkyg]

Spreadsheet coordinates are the X and Y axis alphanumeric designators of a cell, i.e, A-1, K-15, M-22, etc. In Excel, the cell coordinates are in the upper left box just above the spreadsheet.

Having noted that - what are you after? Do you want the contents of that box read or posted somewhere?

 

[armstrda]

you can use a combination of row() and column functions and maybe the address function to get the address of a given cell. But what do you want it for? That would make it easier to help.

 

[Braznor]

Thanks for replying everybody. I use a program called winautomation to extract data from spreadsheets and process it into reports.

I was wondering if Excel can return the Cell cordinates, i.e alphanumeric designators of a cell. A1, B12 C43 etc. into the clipboard with a certain keyboard shortcut or is there a program to achieve?

Also is there a shortcut key to apply format cell to the active cell?

 

[armstrda]

You're probably going to have to look into creating a VBA script that will do this for you.

 

[zzuupp]

Something like this ?

Dim X As Variant
X = ActiveCell.Address
ActiveCell.Value = CStr(X)