Problem Working with Named Ranges

M

montgomerymouse

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to show / hide grouping, linked to label button 3
Problem Working with Named Ranges 1
Macro to Select text from a point given to a specific word 2
Remove Identical words 0
VBA Pivot Table Error 1
VBA SQL Server Stored Procedure creating a Pivot Table 7
Need Help with a VBA subroutine 0
Disable custom menu item based on visible cells 1

Top