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!
|