Thread: Setting a range in a named range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Setting a range in a named range
On Fri, 9 Nov 2012 18:59:35 +0000, Askjerry wrote:



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

Glad to help. Thanks for the feedback.
Reply With QuoteReply With Quote