Select Last cell in named range VBA

[dimitri]

Hi,
I'm looking for the VBA code that will select the last cell in named range. I can select the first cell by using this code:

Range("NamedRange")(1).select

But i don't know how to select the last cell. What I ultimately want to do is insert 2 rows above the last cell in my named range.

Thanks.

 

[Engineer1279]

I know this is an older post, but I came across it while looking for something else. I noticed several answers but none that seemed quite as simple as this. You had asked how to select the last cell in a named range and referenced your code to select the first cell. Anyway, for what it is worth a little over two years later, to select the last row in a named range do this.

Range("[COLOR=#574123]NamedRange[/COLOR]")(Range("[COLOR=#574123]NamedRange[/COLOR]").Count).Select

It seems to work for me anyway; and it doesn't matter if there are blank cells in this list or not.

 

[Peter_SSs]

I noticed several answers but none that seemed quite as simple as this.

That's because the other answers were directed at the OP's ultimate goal, not an intermediate one.

What I ultimately want to do is insert 2 rows above the last cell in my named range.