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

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

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/

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