So when I try to move it into my other macro i get "application defined or object defined error" on the .range("c3") line. Even when I update the sheets and everything. Any clue what's causing this?