@Jolivanes, are you saying this will work for me? It looks like you are creating a shortcut in the code, instead of typing Sheet2 you have it set to read Sheet2 as "sh2". 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.