This is very helpful, we can use this code for any such application...ur way of explanation is very simple and effective. Thanks for making such vedios...
Hi Sir, this vedio is very useful. one issue I am facing, if I want to exclude one or two sheets from my looping then how i can do that because it is getting applied at all sheets now, however in my work 2 sheets should not have the impact of my macro.
Hi can u show us how can we copy a sheet and paste only values in same sheet so that all the formulas from the sheet cell can be removed and omly values remain.
when checking the second version of the code , it would have been easier instead deleting the name of the sheet from each sheet just changing a parameter from Cells(1,1) and the new version of the code will put the name of the sheet to the right or bellow the first one
This is very helpful, we can use this code for any such application...ur way of explanation is very simple and effective. Thanks for making such vedios...
Hi Sir, this vedio is very useful. one issue I am facing, if I want to exclude one or two sheets from my looping then how i can do that because it is getting applied at all sheets now, however in my work 2 sheets should not have the impact of my macro.
Thank you for this video.
How can I avoid 3 specific sheets if I use this vba code?
May you please advise on this?
Thank you! How do I exclude a few sheets?
Simply great
outstanding! Thank you
Glad you liked it!
If we want to ignore different sheets and consider only few sheets for performing some actions how to do
Hi can u show us how can we copy a sheet and paste only values in same sheet so that all the formulas from the sheet cell can be removed and omly values remain.
You should use# " selection.PasteSpecial Paste:=xlPasteValues " instead of regular paste.
when checking the second version of the code , it would have been easier instead deleting the name of the sheet from each sheet just changing a parameter from Cells(1,1) and the new version of the code will put the name of the sheet to the right or bellow the first one
Thnks sir