Forum Discussion
Pasting values to visible cells only
I want to copy values from a particular column in an excel file and paste it in another file in a particular column where I have excluded some rows by means of filtering. However when I paste the val...
You can assign the macro to a toolbar buttons, so the macro will be available on any open workbook & easy to access.
Thanks Cangkir. I did assign the macro to the toolbar button. If I have to use this macro in other excel files, I have to ensure that this xlsm file is kept open when I am working on the other excel files and also have to set "enable VBA macros" option which is bit risky if I fail to change it to old settings after completing my task. Hence I would prefer a long term solution which is having this feature included as part of "Paste Special" menu item.
You might store the macro in a module in your Personal Macro Workbook PERSONAL.XLSB.
It will then be available in all workbooks.
