Problem Working with Named Ranges

Hi,

On one worksheet in my workbook, I have an outline with expandable and
collapsable rows (using the group function). In another worksheet, I have
different buttons which runs different macros that will link me to the
sections of the outline that I want expanded (while the rest remains
collapsed).

I was able to get a macro to work using absolute values for a cell position,
but I have been unsuccesful trying to work with name ranges. This is a
problem, as I frequently add new rows to the outline so I'm constantly having
to update the macro.

Can someone help me put relative values in the macro so that it will adjust
as I add new rows?

I think the best way to tackle this might be to use named 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

FYI, I'm fairly new to macros. Thank you in advance for whatever help you
can provide!

Hi
Try creating Dynamic Ranges. You can find more information on that here.
http://www.contextures.com/xlNames01.html#Dynamic

JG

I'm not sure what the names IIA and SA refer to, but maybe...

Sub SQ5()
Sheets("Horizontal").Select
Rows(2).ShowDetail = True
Range("IIA").entirerow.ShowDetail = True
Range("SV").entirerow.ShowDetail = True
End Sub

And you can do things without selecting the worksheet:

Sub SQ5a()
With Worksheets("Horizontal")
.Rows(2).ShowDetail = True
.Range("IIA").EntireRow.ShowDetail = True
.Range("SV").EntireRow.ShowDetail = True
End With
End Sub

I think it makes it a little easier to read when you're trying to fix it later
on!

montgomerymouse wrote:
>
> Hi,
>
> On one worksheet in my workbook, I have an outline with expandable and
> collapsable rows (using the group function). In another worksheet, I have
> different buttons which runs different macros that will link me to the
> sections of the outline that I want expanded (while the rest remains
> collapsed).
>
> I was able to get a macro to work using absolute values for a cell position,
> but I have been unsuccesful trying to work with name ranges. This is a
> problem, as I frequently add new rows to the outline so I'm constantly having
> to update the macro.
>
> Can someone help me put relative values in the macro so that it will adjust
> as I add new rows?
>
> I think the best way to tackle this might be to use named 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
>
> FYI, I'm fairly new to macros. Thank you in advance for whatever help you
> can provide!

--

Dave Peterson