Hi Chip: nope--haven't had any time to spend on it yet.

Also, to simplify and add clarity, this is what i will want to do:

Based on the values in any of R1-3C[any], unhide all columns; if necessary
hide rows 1-3; and hide column(s) a, b, c (or any of the gazillion columns).

Footnote: if i can do this with Rows 1-3 hidden, that would be good.
Otherwise will add in the code to unhide them at the beginning of the
routine.

I know it's a relatively simple thing to do....just am very rusty on
non-recorded vba such as Case Selects.

"Chip" wrote:

did you get this figured out yet?