Thread: Setting a range in a named range
View Single Post
  #3   Report Post  
Askjerry Askjerry is offline
Junior Member
  
Location: Kyle, TX, USA
Posts: 2
Talking
Quote:
Something like:

Dim MyRange As Range
Set MyRange = Range(Range("ALPHA")(RowIndex:=2), Cells(Rows.Count, Range("ALPHA").Column).End(xlUp))
That worked perfectly! Thank you so very much!

Jerry
Reply With QuoteReply With Quote