View Single Post
  #1   Report Post  
montgomerymouse
 
Posts: n/a
Default 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!