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

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

use outlines,
then for presentation you select level 2 (unhiding the hidden columns)
and the user works with level 1



keepITcool

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


"Stuart" wrote:

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

We might be at cross-purposes here, due to my poor
explanation.

The user has chosen a sheet(s) to print, and has then
opted to hide a column(s). The sheet is a series of
'pages' finishing with a '£' value in col N (£Col) and
a total in col O at the end of each 'page'.

The values in col N above '£' in each page are Nett
values. If the user choses to hide these from the Client,
then they hide Col N.....which hides '£'.

I would like to trap user hiding col N (ideally a way to
trap any specific column being hidden), then if it is
hidden, add '£' to col M (same row) for a normal
sheet, or add to col O for a 'SUMMARY' sheet.

Then when each range ('page') is printed, the '£' is
there for presentation purposes.

Thanks for your responses.

Regards.


"keepitcool" wrote in message
...
use outlines,
then for presentation you select level 2 (unhiding the hidden columns)
and the user works with level 1



keepITcool

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


"Stuart" wrote:

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






---
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

whatever.. i'd get rid of the € column and use cell formatting for the
last column.

if you want to check if a col is hidden

with Worksheets("Sheet1").Columns("C")
if .Hidden then .hidden=false
end with

it's a property from the range object..
however it wont work on a cell, it works on (series of)
Rows and Columns only

=select activecell.EntireColumn.Hidden will work

to just unhide all columns on the sheet use:

activesheet.columns.hidden=false



that what you wanted?


keepITcool

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


"Stuart" wrote:

We might be at cross-purposes here, due to my poor
explanation.

The user has chosen a sheet(s) to print, and has then
opted to hide a column(s). The sheet is a series of
'pages' finishing with a '£' value in col N (£Col) and
a total in col O at the end of each 'page'.

The values in col N above '£' in each page are Nett
values. If the user choses to hide these from the Client,
then they hide Col N.....which hides '£'.

I would like to trap user hiding col N (ideally a way to
trap any specific column being hidden), then if it is
hidden, add '£' to col M (same row) for a normal
sheet, or add to col O for a 'SUMMARY' sheet.

Then when each range ('page') is printed, the '£' is
there for presentation purposes.

Thanks for your responses.

Regards.


"keepitcool" wrote in message
...
use outlines,
then for presentation you select level 2 (unhiding the hidden
columns)
and the user works with level 1



keepITcool

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


"Stuart" wrote:

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






---
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