Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Problem Working with Named Ranges
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! |
#2
|
|||
|
|||
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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word User Network Problem | Microsoft Word Help | |||
Save As is not working due to macro security settings | Microsoft Word Help | |||
Problem with Hyperlinks, Embed, and Page _ of _ | Microsoft Word Help | |||
Font Problem in Outlook with Word as E-mail Editor | Microsoft Word Help | |||
Word 2003 autocomplete not working | Microsoft Word Help |