Hi all,
I have the following code with a Get folder function to open and process CSV file contained within a folder.
The code changes the format of the date in column D and saves as text in YYYY-MM-DD format. The range of cells has until now been static in D2:D228, but unfortunately it now need to vary.
So I'm trying to modify the code to apply the formula in column F but only until it reaches the last row of data in column A.
I've added the following code into into the procedure but unfortunately it hangs
Here's the amended code:
Any ideas what's gone wrong?
Thanks
David
Original code below
Bookmarks