Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Bryant Smith   on Jan 30 In MS Office Category.

  
Question Answered By: Jack Williams   on Jan 30

I don't see the "named range" mentioned in your subject, but you seem
to have two problems - one with parentheses, and one with reversal of rows
and columns.



To select from say C5 to J20, you would write:

With Worksheets(1)

.Range(.Cells(3, 5), .Cells(20, 10)).Select

End With



Do you see how you have incorrect parentheses, and the rows  and columns seem
to be at least partially reversed?

If this doesn't clarify for you, maybe you could let us know exactly what
you're trying to select.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on highlight a range using a named range Or get search suggestion and latest updates.


Tagged: