Problem Working with Named Ranges

[Guest]

Hi,

I'm fairly new to macros. I was able to get a macro to work using absolute
values for a cell position, but was unsuccesful trying to work with name
ranges.

Here's the script that worked with absolute values:

Sub SQ5()

Sheets("Horizontal").Select
Rows(2).ShowDetail = True
Rows(96).ShowDetail = True
Rows(97).ShowDetail = True

End Sub


Here's what I wrote that is *not* working with ranges.


Sub SQ5()

Sheets("Horizontal").Select

Rows(2).ShowDetail = True
Range("IIA").ShowDetail = True
Range("SV").ShowDetail = True

End Sub

Thank you in advance for whatever help you can provide!

 

[Jezebel]

You'll more likely get an expert response if you post the question to an
Excel forum rather than a Word forum. From my understanding of the Help
topic, ShowDetail is valid only if the referenced range is part of a pivot
table or the range is in a single summary row or column.