Sum in hidden column

  • Thread starter Thread starter davegb
  • Start date Start date
D

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!
 
Are you trying to select the cell?

(e-mail address removed)
 
Crowbar said:
Are you trying to select the cell?

(e-mail address removed)
Click to expand...

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple SUM's in a column 15
Sum Columns with Specific Headings 6
Sum Function When Formula Produces #N/A 2
Sum 3
summing columns when not hidden 7
sum the column 3
SUM - IF - AND 7
Insert columns and values programmatically with IF statement 9

Back
Top