I have an interesting question for everybody here. Let me see how to best explain it.
I start in the code making sure column Action Plan completion has a value in it. Copying in the issue modified column if neccesary.
'Back fill last modified 'I need to start with the first data row (3) and the action plan completion column Let intcurrentrow = 3 Let intcurrentcol = intactionplancompletion Do Until intcurrentrow > intmaxrow If Cells(intcurrentrow, intcurrentcol).Value = "" Then Let Cells(intcurrentrow, intcurrentcol).Value = Cells(intcurrentrow, intissuemodified).Value 'Need to ensure that everything is formatted as a date Let Cells(intcurrentrow, intcurrentcol).NumberFormat = "m/d/yy h:mm AM/PM" End If Let intcurrentrow = intcurrentrow + 1 Loop
Later, I place this formula in a given cell.
The info I copied above is placed into the column K.
When I run the macro, the cell formula outputs "#value".
However, if I go double-click then enter the cell calculates just fine.
I've tried excels overall recalculate function, but that doesn't change this.
Does anybody know how to simulate a double-click on a cell?
Any other suggestions?