VBA Unhiding Rows Bugs...

**V8Maverick** · 07-27-2010, 05:20 AM

Hi All,

Yet another post from me! Got a bug in my VBA that doesn't seem to make sense.

I have three drop downs calling three simple functions, but the problem is this:

Please Login or Register  to view this content.

This works fine and reveals only rows 31 to 43, but change the numbers and it all goes wrong:

Please Login or Register  to view this content.

This is unhiding rows 7 to 28 - Am I missing something here? If I change the numbers to 31:43, it just unhides 31 to 43.

Likewise, the final script, though being set to 19:31 is bringing in 18 to 31. I can't figure this out and I'm wondering if I'm missing the blindingly obvious?

Thanks

**Bob Phillips** · 07-27-2010, 05:32 AM

Not sure that I understand what you are syaing, but try simpliying it and removing all of the selecting

Please Login or Register  to view this content.

**Domski** · 07-27-2010, 05:34 AM

Do you have merged cells or anything like that covering the areas that are wrongly being unhidden?

A sample workbook where it's not working right would probably help to suss out where the issue is.

For info you never really need to use select with vba. You code can be written like this:

Please Login or Register  to view this content.

Dom

**V8Maverick** · 07-27-2010, 12:09 PM

I've got a text box floating about to the right, but it's set not to size or move with the cells. I'll cut the relevent worksheets out and post here so that you can see what is (or isn't) happening.

**V8Maverick** · 07-27-2010, 12:17 PM

Here is the sample sheets. Selecting Yes, or No to the Michelin / BFGoodrich / Kormoran actions in "CUST_DETAIL" should unhide the historic sales boxes for their brand in "AMP&LY"
Michelin: Rows 7:18
BFGoodrich: Rows 19:31
Kormoran: Rows 31:43

I'm sure now that someone is going to point out that I am missing the bleeding obvious, but hey ho. It's driving me mad.

EDIT: Attachment removed as initial problem solved

**Leith Ross** · 07-27-2010, 02:27 PM

Hello V8Maverick,

I named a range for each manufacturer "Michelin", "BFGoodrich", "Kormoran" to make hiding and displaying the ranges easier. Here is code now...

Please Login or Register  to view this content.

The attached workbook contains these changes.

**V8Maverick** · 07-28-2010, 07:42 AM

Okay, those named ranges seem to have done the trick - Though they only seem to point to the rows I was previously asking to hide by number rather than name. Oh well, another brain bender put to bed. Thanks!

Any idea what may have been causing the initial problem?