Dear Experts,
I have found a few very good macros over the net which I think I can use in my day to day life but my problem is:
These macros don’t work when I paste it in my VBA . Things common with all these macros are
1. Name has text within brackets eg. Sub test(byVal Target Pivot Table)
2. F8 also doesn’t work with any of these tried with new workbooks also
3. After pasting the macros in vba when I do view macros and try to open the macro from macros in this workbook I cant see the name of the macro
4. If text is removed from the brackets and () is used, F8 starts working and it gets stuck at the line where it says target
Looking for some guidance on how to handle these macros with text within brackets.
Best Regards/VKS