I have the following line to set the date format in a workbook:
If you look at the formatting after the macro runs, it says it has changed, but for all real purposes, the column has not changed at all. Only if you double click into a cell is the format change actually applied, and then only for that one cell. Am I doing something wrong? I would hate to have to individually double-click the thousands of lines of dates here...
Please Login or Register to view this content.
Thanks!
Can you post the rest of the code?
BTW you change the format directly there isn't any reason to select it first.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Are you wanting to convert Text-type dates into Serial-type dates? If yes, maybe try something like this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks