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!

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.




"montgomerymouse" wrote in
message ...
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!