Excel Vba

[AberdeenAl]

Writing Some VBA in Excel and trying to select a dynamic range. I have only 2 columns but number of rows is determined by a variable. How do I select this range? Thanks.

[pinkyboyid]

Maybe this link will help:

http://www.excel-vba-easy.com/vba-programming-range-excel-vba.html

[dr b]

dynamic ranges described here:

http://stackoverflow.com/questions/12064731/excel-vba-select-a-dynamic-cell-range

[AberdeenAl]

Thanks both. Got the answer I was looking for and my code is working perfectly now!