Dear friends,
I try to hide a # of rows from cell value (E1) .. 21
therefore I wrote
Rows("(Range(E1).value):25").EntireRow.Hidden = False
(in my case Cell (E1) = 10, but can vary in value.
Obviously there is a type mismatch. What do I do wrong here?
Many thanks for your replies.
Highly appreciated.
Gr.
john.
I try to hide a # of rows from cell value (E1) .. 21
therefore I wrote
Rows("(Range(E1).value):25").EntireRow.Hidden = False
(in my case Cell (E1) = 10, but can vary in value.
Obviously there is a type mismatch. What do I do wrong here?
Many thanks for your replies.
Highly appreciated.
Gr.
john.