Sum in hidden column
 

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!

Sum in hidden column
 

Are you trying to select the cell?



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

Sum in hidden column
 

Crowbar via OfficeKB.com wrote:
Are you trying to select the cell?



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