crumbcounter
New Member
- Joined
- Sep 27, 2016
- Messages
- 11
Hello one of two lines are not working in Macro
Columns("C:C").NumberFormat = "[$-x-sysdate]dddd, mmmm dd, yyyy"
Columns("D:D").NumberFormat = "[$-x-sysdate]dddd, mmmm dd, yyyy"
Only works for column C. I have tried combining the lines "C:D", reversing order, and only having line for D. Column D is not reformatting. Any clues?
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Columns("C:C").NumberFormat = "[$-x-sysdate]dddd, mmmm dd, yyyy"
Columns("D:D").NumberFormat = "[$-x-sysdate]dddd, mmmm dd, yyyy"
Only works for column C. I have tried combining the lines "C:D", reversing order, and only having line for D. Column D is not reformatting. Any clues?
Task | Resources | Start Date | End Date | Status |
Addresses, Dates, Contact Info, Drawings, Drops, and Other Info | Ben Gallahan | 29-Nov-16 | 08/May/2017 | Upcoming |
Set up Recycling | Ben Gallahan | 31-Mar-17 | 14/Apr/2017 | Overdue |
IT Presence Book Flight and Hotel | helpdesk | 14-Apr-17 | 18/Apr/2017 | Upcoming |
IT Building Access | Ben Gallahan | 31-Mar-17 | 21/Apr/2017 | Upcoming |
IT Suite Access | Ben Gallahan | 31-Mar-17 | 21/Apr/2017 | Upcoming |
Give IT Presence Schedule and Contacts | Ben Gallahan | 14-Apr-17 | 21/Apr/2017 | Upcoming |
Make sure Workstation items are sent to current office | Ben Gallahan | 14-Apr-17 | 23/Apr/2017 | Upcoming |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>