Hi guys! , I am new in using and reading Macros in Excel and I have a hard time understanding these lines. Could you guys help me please, i cant understand those highlighted in yellow. Your help is very much appreciated.
Thanks!
Hi guys! , I am new in using and reading Macros in Excel and I have a hard time understanding these lines. Could you guys help me please, i cant understand those highlighted in yellow. Your help is very much appreciated.
Thanks!
the first yellow highlighted line...
is for Paste Special ..
just as when you copy a cell and right click to paste special.. to paste Values only
the other arguments like... Operation , skipblanks are complementary ones..
You can know their utility in the office help..
the second Yellow highlighted line..
is for protecting the worksheet..
just as you use protection option with a password..
For other arguments and their utility .. refer MS excel help....
Don't forget to click *
Thank you so much for the clearing it out. thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks