Re: Cell Value & unchanging Date With Macro run

You are running the code only once, after copying all of the values, right?
Also, maybe your "empty" cells aren't really empty.

If you still don't get it working then post your code.

Tim.



"Desert Piranha"
<Desert.Piranha.222j0a_1137987301.2897@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Desert.Piranha.222j0a_1137987301.2897@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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
    ... Does the fact that is every other cell have any thing to do ... Desert Piranha Wrote: ... > Hi Tim, ... > Thx for responding. ...
    (microsoft.public.excel.programming)
  • Re: Clear the content of a cell
    ... Ken., thx.. ... you would need VBA to do that. ... >most functions that refer to that cell or a range ... >truly empty in the real sense of the word. ...
    (microsoft.public.excel.misc)
  • RE: Count number of row where are data
    ... > based on different sheets, I would like to retreive the number of row where ... > i just want to count how many rows have the A cell not empty. ...
    (microsoft.public.excel.misc)
  • Re: IF Statement
    ... In any cell enter ... there could be a formula in E10 that returns "" if a condition is not ... so E10 is not really empty but it will return as True. ... Many thx, ...
    (microsoft.public.excel.misc)
  • Count number of row where are data
    ... sheet 1 has 156 rows ... i just want to count how many rows have the A cell not empty. ...
    (microsoft.public.excel.misc)