Hiding Rows based on Drop Down menu selection

[smurph_27]

I already have a macro that can resize columns to show only the date range selected from a drop down menu. (date range is listed along 1 row)

I am trying to do the same for some worksheets that have the date range listed down one column.

The first section shows the example with the date range listed along a column. This is working. The second section is my attempt to get the same result for when the date range is listed down a column instead.

How do i do this? Thanks for your help!

Please Login or Register  to view this content.

[Richard Buttrey]

I already have a macro that can resize columns to show only the date range selected from a drop down menu. (date range is listed along 1 row)

I am trying to do the same for some worksheets that have the date range listed down one column.

The first section shows the example with the date range listed along a column. This is working. The second section is my attempt to get the same result for when the date range is listed down a column instead.

How do i do this? Thanks for your help!

Please Login or Register  to view this content.

What are the values of the variables for colnum3, colnum4, rowx3 and rowx4 ?
Are the ranges "rowx3" and "rowx4" named in the s/s?

What are you trying to achieve with the .Resize operation?

Rgds

[smurph_27]

I figured it out, silly me, I called out the wrong worksheet. No wonder it didn't work.