Hi,
I need to use text to columns to convert text to date but I am having an issue that the recorded macro wont work for the newly inputted data it only works from the top of the column until the new data starts, Can I use code and what code to determine which cells within the column are formatted as date so that I can start thereafter?
Thanks
Johnny