I write VBA and VBS but it takes me a long time to write anything substantial and I can read much better than I can write it haha.
Basically my problem is this: I need to convert certain entire columns with thousands of entries to text in VBA because there is a bug in excel which converts all but certain random cells to text, requiring it to be done manually. They are in number format and I want to ensure that every cell in that column is a number. It is something that I do over and over again in the same columns for about a hundred times, so it might save me a ton of time...
Can someone write the few lines of code I would need to do this? I understand the concept of what I need to do and the steps I just cant get code it to work right and I know its a simple task for a good programmer. =)
Thanks
Michael
