Col N contains user data. Every 50 odd rows or so, a '£' value
coincides where a 'Collection' row occurs. I need to permit
user to hide £Col, but for presentation purposes I wish to
add the '£' value as previously described.

Regards.

"keepitcool" wrote in message
...
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





---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003