使用另一个单元格值来引用excel VBA中的范围

I have a work sheet that has some data in it. To simplify adding it into an email, I've created some code that upon a button press would select a range of cells and save it as an image to upload into email. The current code is the following: I have a work sheet that has some data in it. T