Hi

I have a select case statement that refers to various cells in different
rows from each other on a worksheet. Based on the answer that the user
provides in these cells a function will be performed whereby a specific row
ranges will be hidden or not.

The problem that I have is that the user does have the option to insert rows
between these cells. This will now have the effect that a code that was
linked to a specific range will now hide a different range that was intended
as the ranges has now shifted downwards.

Is there anyway to overcome this problem?
Hein