I could have sworn I have done this before. I want to copy cells from a sheet that is not the activesheet. It bugs unless I select the "Reconfigure" sheet first. Why?


Sheets("Reconfigure").Range(Cells(2, 8), Cells(5000, 8)).Copy