Hi;
I am trying to copy the data from one sheet to other through getopenfilename command. I face 2 issues.
1: Initially, when i run my code, it copy the data and past it into the directed workbook. But after 2 tries, my code execute but don't copy & paste the data.
2: In order to pin point the problem, when i opted step in process, it skip the code in the start where variables are declared and directly jump to application.getopenfilename line.
I am trying to copy the data from one sheet to other through getopenfilename command. I face 2 issues.
1: Initially, when i run my code, it copy the data and past it into the directed workbook. But after 2 tries, my code execute but don't copy & paste the data.
2: In order to pin point the problem, when i opted step in process, it skip the code in the start where variables are declared and directly jump to application.getopenfilename line.