Re: Cell Value & unchanging Date With Macro run


Hi Tim,
Thx for responding. I will check this out and get back as i have to
leave for about an hour.
BUT it will always be values (text or numbers) no formulas.

Thx Again
DaveTim Williams Wrote:
> Are you only copying values? Will there ever be formulas?
>
> how about
>
> Dim c as range
> For each c in Sheet1.Range("A6:A42")
> if c.value<>"" then
> c.value=c.value & " " & Format(Now,"mm-dd")
> end if
> Next c
>
> You would run this directly after the copy-paste routine. It might be
> better to modify your existing routine, but difficult to suggest how
> without
> seeing it.
>
> Tim


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28934
View this thread: http://www.excelforum.com/showthread.php?threadid=503878

.