Hi all,

Can I refer to a range within a named range? My named range looks something like this:

Range("A1:C1,F1:H1,M1:O1")
Now I only want to refer to the second part within that range, which would be Range("F1:H1"). How can I do that within VBA?