Quote Originally Posted by jnix612 View Post
I don't want to add an extra line, I just want to add the code to identify where my range of cells are located which will be in a different sheet.
Change With Sheet1 to With Sheet2 or…