Re: how to include special characters in a formula?
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Sun, 10 Jul 2005 11:38:55 -0500
See one more reply at your other thread.
a wrote:
>
> Hi,
>
> I have tried the suggestion below, but it still doesnt work.
> -------------------------------------------------------------------------
>
> ya, i tried tat,
> VBA would give me a "expected: line nubmer or label or statement or end of
> statement" compile error.
> i guess its bcos, by using double quotes, we break the formula up into 3
> parts.
>
> "Chip Pearson" <chip@xxxxxxxxxxxx> wrote in message
> news:uffx2rVhFHA.576@xxxxxxxxxxxxxxxxxxxxxxx
> > Use double quotes instead of apostrophes.
> >
> > Range("N2").FormulaR1C1 = "=HOUR(RC[-1]" & ":" & MINUTE(RC[-1])"
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> >
>
> >> one minor question.
> >> how do you include special characters in formula? i am tryign to
> >> achieve something like 9: 30.
> >> with the semi-colon separating hours and mins.
> >>
> >> Range("N2").FormulaR1C1 = "=hour(rc[-1])& ':' &minute(rc[-1])"
> >>
--
Dave Peterson
.
- Follow-Ups:
- References:
- Prev by Date: Opening *.txt by code with varible path
- Next by Date: Re: Opening *.txt by code with varible path
- Previous by thread: how to include special characters in a formula?
- Next by thread: Re: how to include special characters in a formula?
- Index(es):
Relevant Pages
|
