Simple VBA Range Selection

[Gian624]

Hi Mr. Excel Family,

I know I am overthinking this and its probably simple so here goes:

I am trying to set "ChartRange" as a range that includes cells H5:K5 and everything below as the range of cells to use in a chat. For some reason, I can't figure out how to select the original range and then the range below. The current broken code I have is:

Set ChartRange = Range(("H5:K5"), Range(Selection, Selection.End(xlDown)).Select

Thanks for the help,
Matt

 

[Scott T]

Try

Set ChartRange = Range("H5:K" & Cells(5, "K").End(xlDown).Row)

 

[Gian624]

Briliant! Thank you. I had to make one slight modification but it worked.

 

[DanteAmor]

A couple of other options

Set ChartRange = Range("H5:K5", Range("H5:K5").End(xlDown))

Or

If the adjacent cells do not contain information:

Set ChartRange = Range("H5:K5").CurrentRegion