Forum

Thanks Alan, the supplement information.

Thanks Alan the altenative, they also worlk perfectly.

Thanks Purfleet, Lionel , this works out exactly and precisely remove all leading and trailing spaces in every cells. My sincere thanks again, really...

BTW , when you define the parameter what do your mean by Ligne? Dim Ligne As Integer, cell As Range

Thanks Lionel your support. Pls refer attached again after executed the macro, some cells highlighted, for samples consequetive leading spaces,comm...

Thanks Lionel, but cells Leading spaces still can not remove.

Thanks Miguel, problems finally fixed, ie file name retained in subject thanks support!

Dear Miguel, I try the macro with live data, but File name still can not be attached in subject. Pls help further So far no error code prompt, ...

Really thanks again Miguel, will try on the new Macro with actual data.

So Sorry causing too much confusion so far all my poblems in these posts has been clear and settled; except the last item we want to show in the File...

Sorry I should have attached modified macro file for further modification...

In the Email Macro how to modify and include attachment File name in the Email Subject : (1) Monthly Report & 12349 attachment file is...

One more request how to add File Name in the Subject Email body for example : Subject : AR Monthly report : 12349 Attachment : 12349.xls ...

Hi Miguel, thanks the hints again. So after adjust the Macro security level by the IT Administrator to my PC, now the Macro works with Ms.Office 2019...