In the VBA code associated with the Excel spreadsheet the VBA sub does not compile. It says that cell is not defined.
i got this VBA code off the internet and I would expect it to be correct. Anyway, it does not compile because of that error or bug.
This code is to go down a selected column in the Excel spreadsheet and add a apostrophe to each cell making the number now a text value.
That way it should import into Excel since it is all one type of cell - text. Hence no "Type Conversion Failure" error messages.
But at this point it will not even compile. I must define cell, but i would expect t to be a reserved word and not need to be defined.
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed