Hello the experts,
I'm not good with VBA but I use it a lot, I usually record some stuff then ask my friend google about what I can't get recorded. I know all my macros are probably very weak but as long as I'm the only one at risk it's not an issue. But this time some colleagues are interested and I don't want to "sell" them a rotten file. So... Would you please have a look on my macros and let me know if you see something that should be improved so I can share my file with good chances it will work for other people ? Your corrections are obviously welcome, but also your advices to help me understand why I should do this and not do that...
Thank you very much for your help, Kind regards,
MACRO 1 - I use this one A LOT, it's stored in my personal.XLSB for the numerous times I have to deal with french dates read as text and want to transform them into actual dates. I use the macro "on the go" or I use it within other macros.
Selection.TextToColumns Destination:=Range(Selection, Selection.End(xlDown)), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 4), TrailingMinusNumbers:=True
Selection.NumberFormat = "[$-en-US]d-mmm-yy;@"