Re: Cell Value & unchanging Date With Macro run


Hi Tim,
Ok Its working kinda. Im getting the correct format but this is whats
displaying in the cell:
453 01-22 01-22 01-22 01-22 01-22 01-22 01-22 01-22 01-22 01-22 01-22
01-22 01-22 01-22 01-22 01-22 01-22 01-22 01-22

he he he. i will work on it tonight and see what i can figure out.

Does the fact that is every other cell (or row) have any thing to do
with this result?

Thx much,
Dave
Desert Piranha Wrote:
> 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
> Dave


--
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

.

Relevant Pages

  • Re: Cell Value & unchanging Date With Macro run
    ... maybe your "empty" cells aren't really empty. ... "Desert Piranha" ... > Does the fact that is every other cell have any thing to do ... >> Thx for responding. ...
    (microsoft.public.excel.programming)
  • Re: Cell Value & unchanging Date With Macro run
    ... Hi Tim, ... Thx for responding. ... > You would run this directly after the copy-paste routine. ... Desert Piranha ...
    (microsoft.public.excel.programming)
  • Re: Userform help needed
    ... This has me heading in the right direction, ... > Same link as above Tim, ... >> and then run Ron's macro. ... >>> N7 gets incident number from a cell on another sheet and that data is ...
    (microsoft.public.excel.programming)
  • Re: Validate Cell Value
    ... Thanks, Tim, this seems to work pretty good. ... macro over three different sheets. ... It also assumes that cell entries are single cell. ...
    (microsoft.public.excel.programming)
  • Re: How to copy a cell and horizontally expand the paste along hea
    ... Thx for the reply. ... the first column is filled in on 10 rows high; ... Double-click on the black bold cross in the lower-right of this cell. ...
    (microsoft.public.excel.misc)