cgmojoco
Well-known Member
- Joined
- Jan 15, 2005
- Messages
- 699
Hi there -
I need VBA to search through column headers for the word
.
If the column header contains date, I need the column of data to be set to this custom format:
YYYY-MM-DD hh:mm:ss
Then, the column should have each of its cells wrapped in quotes (to preserve the format on .csv save).
Next column, rinse, repeat until all cells in columns with
have had their format changed and have had an extra layer of protection from Excel changing the format again, by having them be wrapped in quotes.
Thanks in advance!
I need VBA to search through column headers for the word
VBA Code:
date
If the column header contains date, I need the column of data to be set to this custom format:
YYYY-MM-DD hh:mm:ss
Then, the column should have each of its cells wrapped in quotes (to preserve the format on .csv save).
Next column, rinse, repeat until all cells in columns with
VBA Code:
date
Thanks in advance!