Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting help...
Hi,
I need to create a macro which will put the current date in column for any row which contains text in Column A from A17 to A500, in al grouped worksheets. The date should only change when the macro i activated. Thanks in advance. Best Regards, Mjac -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting help...
Hi,
Haven't been able to try either macro over the weekend but thank yo for replying. Yo what I mean by "grouped" is all selected worksheets. By holding ctrl+single click I select particular worksheets out of th hundreds and need to enter the current date in those only. I also nee the date to be a one time thing. In other words I don't want it t update, only when the command button is clicked. Thanks again. Regards, Mjac -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting help...
Thanks, for the explanation... I actually realized what you meant after I
read Vasant's post; which should work just fine. The date will not change. "mjack003 " wrote in message ... Hi, Haven't been able to try either macro over the weekend but thank you for replying. Yo what I mean by "grouped" is all selected worksheets. By holding ctrl+single click I select particular worksheets out of the hundreds and need to enter the current date in those only. I also need the date to be a one time thing. In other words I don't want it to update, only when the command button is clicked. Thanks again. Regards, Mjack --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting help...
Thank you for the help. It works perfectly. I know this should b
simple but how would I have the macro also change the date to re text? Thanks again. Best Regards, Mjac -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |