dougmarkham
Active Member
- Joined
- Jul 19, 2016
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
Hi Folks,
I have an excel report that has been exported from a website. The date column has some hidden formatting on it, so that when I format the column using:
The date remains in the format: DD/MM/YYYY.
When I double click on any cell, the hidden date format is lost as expected, as excel registers that I have re-entered data.
In the past, I've gotten away with using VBA to run Text to Columns in order to simulate the double-clicking down a range of cells in a column e.g.
However, for some reason, today the code just has no effect. The options are set to automatic calculation so I am stuck, after a google search session.
Would anyone be able to help me find a more robust method (or suggest one) of simulating double-click in all cells in a column?
Kind regards,
Doug.
I have an excel report that has been exported from a website. The date column has some hidden formatting on it, so that when I format the column using:
VBA Code:
Range("RepTable[Delivery Date]").Select
Selection.NumberFormat = "yyyymmdd"
When I double click on any cell, the hidden date format is lost as expected, as excel registers that I have re-entered data.
In the past, I've gotten away with using VBA to run Text to Columns in order to simulate the double-clicking down a range of cells in a column e.g.
VBA Code:
Range("RepTable[Delivery Date]").Select
Selection.TextToColumns Destination:=Range("E2"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
Would anyone be able to help me find a more robust method (or suggest one) of simulating double-click in all cells in a column?
Kind regards,
Doug.