I had my macro working and then I change the sheet names and now I am getting a Run-time error '9'. I have tried many option to fix it and no luck. I hope some one can help me with his issue. Here is my macro:
Sub copycolums()
Dim lastrow As Long, erow As Long
lastrow =...