Sum in hidden column

[davegb]

I want to sum the contents of 2 visible columns, but hide the sum and
test it's value for a macro. It doesn't work when I hide the sum
column, it's giving false results. Is there a workaround for this, or
just a better way?

Thanks as always!

[Crowbar via OfficeKB.com]

Are you trying to select the cell?

prec_tec@yahoo.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200605/1

[davegb]

Crowbar via OfficeKB.com wrote:
> Are you trying to select the cell?
>
> prec_tec@yahoo.com
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...mming/200605/1

Thanks for your reply. Thinking about it after I posted, I realized I'd
be better off just unprotecting and unhiding the whole workbook while
the macro runs, the re-hiding and reprotecting it. Then the other
becomes a non-issue.

And no, I wasn't trying to select it.