dualhcsniatpac
Board Regular
- Joined
- Feb 18, 2009
- Messages
- 126
I need some help in vba coding.
What I am shooting for is that if the date is a saturday or sunday it turns the text red. I am submitting info on a form to another file. I figured there are 2 ways. To all at once format the whole row (Which will be dates: 03/17/2009) or to format the data at the time of insertion. I do not know which one would be faster to process.
What I have for the row editing so far is Columns("A:A,W:W").???????
Sorry if I left any needed info out.
Thanks,
David
What I am shooting for is that if the date is a saturday or sunday it turns the text red. I am submitting info on a form to another file. I figured there are 2 ways. To all at once format the whole row (Which will be dates: 03/17/2009) or to format the data at the time of insertion. I do not know which one would be faster to process.
What I have for the row editing so far is Columns("A:A,W:W").???????
Sorry if I left any needed info out.
Thanks,
David
Last edited: