In VBA, there is 3 types of Newline characters.
- vbCr – Carriage Return CR
- vbLf – Line Feed LF
- vbCrLf – Carriage Return CR + Line Feed LF
VBA is a very good tool to manage data. I always write some mini VBA programs to manipulate database data and create SQLs. Apart from programming, it also gives me some valuable memories with Tinyan
Let’s back to the topic. In VBA, we use Mid() to substring. Continue reading