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! |
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 |
All times are GMT +1. The time now is 04:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com