This I thought would be a relatively simple task to undertake, but I've spent the past day trying to get it to work to no avail.
Basically I have a column (A1:A5541) of imported data in timestamp form: hh:mm:ss in Excel. I have changed the cell format so that it's recognised as a time index, however, it appears that for it to be properly recognised in that way I need to go through each cell, click on it, then select the tick box in the formula display and repeat for all 5541 values.
As you'd imagine I thought of trying to speed this up by trying to write a quick VBA script in Excel to do this, however I cannot get it to work.
My code is:
Dim rCell As Range
For Each rCell In Range("A1:A5541")
When this is run I get a runtime error 1004. And I'm sure that the 'Select' command if it were to work wouldn't achieve the same effect as clicking on the 'Tick' in the formula window.
Does anyone know how I can simply iterate through each cell in the column, select the 'tick' box automatically and then move on to the next value?
Thanks in advance for your help.