Hi,
I created a macro that required a paste of value from another spreadsheet.
So the user will open an excel file, then copy the data from that excel file, then paste into the "Table" of my macro.
However, if they all do "Paste As Values", then it will be fine. However, it they just paste by doing CTLR-V, I want to have a code that will format all data in my table to "Calibri, font 10, black, and no border".
What will be the best way to do so?
Thanks
Bookmarks