Selecting Multiple cells when using "Selection.End(xlUp)"

[Alvin Hunter]

Hi,

Hope everyone is well.

I'm would like to shorten the following, if possible. I've been looking all over and haven't found a way to select multiple cells on a single "Selection.End(xlUp)" or down for that matter. LOL

Trying to select col E through H in one swoop.

Thanks in advance.

Please Login or Register  to view this content.

[jolivanes]

Please Login or Register  to view this content.

BTW, it's not clear to me what you want done after that though. Maybe you can let us know.

[Marc L]

As a good code often does not need to select anything …

[Alvin Hunter]

Thank you jolivanes. This works perfect. I was simply trying to shorten the code. The next step is "FillDown" to bring down some formulas from the above cells.

[jolivanes]

Re: The next step is "FillDown" to bring down some formulas from the above cells.
That's what I thought but I did not know how far down.
Anyway, if you're happy with what you've got so far, that's good for now.

[Fluff13]

This will fill down Cols E:H to the last row on Col D

Please Login or Register  to view this content.