I have a workbook with 5 worksheets.
I made some VBA prgram initiating in worksheet-1.
Is it possible with this same VBA program to choose other worksheets,(worksheet-2) copy some cells from worksheet 2 and also paste them in the same worksheet-2.
This will be repeated with worksheet 3,4 5, and in the end to come back to worksheet-1.
I tried to get VBA codes recording macro, but when i put everything in my VBA program, doesn't work. As soon as jumps from worksheet 1 to worksheet 2, it stops.
I made some VBA prgram initiating in worksheet-1.
Is it possible with this same VBA program to choose other worksheets,(worksheet-2) copy some cells from worksheet 2 and also paste them in the same worksheet-2.
This will be repeated with worksheet 3,4 5, and in the end to come back to worksheet-1.
I tried to get VBA codes recording macro, but when i put everything in my VBA program, doesn't work. As soon as jumps from worksheet 1 to worksheet 2, it stops.