I stopped using a separate column for Currency sign when I transferred
from Lotus 123 to Excel in 1990. I use number formatting instead.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Stuart" wrote:

How best to detect if a column (£Col) has been hidden
by the user, and if it has, then add a '£' to the cell
immediately to the left of it (same row), please?.

Since that cell will already contain data, I need to place
the '£' at the very righthand boundary of the cell.

So:
the original layout was:

Col M N O
Row
56 Collection £ 225404.29

If user hides col N, then I need to get '£' into M56
like 'Collection £', and if col M is not wide enough
then I need to widen it.

If the sheet is called 'SUMMARY' then '£' cannot go
into M56. It will have to go into O56, like
'£ 225404.29'.

O56 contains a SUM formula. Is that a problem?

Any help with any of these questions would be much
appreciated.

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.505 / Virus Database: 302 - Release Date: 30/07/2003