refer to range within named range

[esbencito]

Hi all,

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

Please Login or Register  to view this content.

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?

[rorya]

Do you mean that you have a named range that refers to Range("A1:C1,F1:H1,M1:O1"), or are you calling that a named range?

Assuming you have assigned the range to a variable called rg, you can use rg.Areas(2) to refer to the second area.

[esbencito]

Please Login or Register  to view this content.

worked well for me! Needed this for the unhiding columns code in my other thread! Thanks!!