VBA is Stubbornly Interpreting 10/12 as Datehttps://social.msdn.microsoft.com/Forums/en-US/f3c6afe8-36f1-43e7-b29e-68fd1a0432e4/vba-is-stubbornly-interpreting-1012-as-date?forum=isvvba
- I’ve got a collection and a string variable declared
- I select the sizes in my listbox and then populating the myCollection collection from that list
- I am making sure that the currentValue is a string before I paste it in a cell
- Still Excel is interpreting it as date !
- THESE ARE SIZES NOT DATES! I don’t want Excell to format those cells for me and I think I’m making myself clear when I specifically say that this is a STRING and not a date or variant!
- Also - each time (despite me formatting the cells manually) Excel annoyingly changes the cell alignment to the right so I need to select the range and change it to xlLeft
- How do I stop excel formatting the cells for me when I don’t want it to ???
Please help