angel_ Well-Known Member Licensed User Longtime User Mar 3, 2022 #1 Does not detect columns with letter Z, for example: B4X: Private Sub AddressCells Log(xl.AddressZeroToString(50, 0)) Log(xl.AddressZeroToString(51, 0)) Log(xl.AddressZeroToString(52, 0)) End Sub 'Return 'AY1 'B@1 <-- ?? 'BA1 It replaces it with @ Attachments Products1.zip 2.1 KB · Views: 175
Does not detect columns with letter Z, for example: B4X: Private Sub AddressCells Log(xl.AddressZeroToString(50, 0)) Log(xl.AddressZeroToString(51, 0)) Log(xl.AddressZeroToString(52, 0)) End Sub 'Return 'AY1 'B@1 <-- ?? 'BA1 It replaces it with @
Erel B4X founder Staff member Licensed User Longtime User Mar 4, 2022 #2 Fixed in v2.07. Upvote 1 Solution