Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting rid of a hidden column behind the front column | Excel Discussion (Misc queries) | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Hidden Column A | Excel Discussion (Misc queries) | |||
Hidden column | Excel Discussion (Misc queries) | |||
Getting column width of a hidden column? | Excel Programming |