I currently have a range hard coded as

RangeTwo = "A2:E11" 'Data Range

I would like to modify this to have the E11 range adjust to suit the number of record, I have tried to replace the above with:

LastRow = Range("E" & Rows.Count).End(xlUp).Row
RangeTwo = "A2:E & lastRow"

Obviously (or I would not be writing) without success. Any help is appreciated.

a