syntax question

Hi XLers

This code fragment works well, resulting in a cell value of, for example,
Teacher

Worksheets("PrintRpt").Range("C1").Formula =
"=INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))"


But, I want the cell value to be Job Title: Teacher

I know this should be simple, but I can't get the syntax to work?

TQ for any help
Giselle

Like:

Worksheets("PrintRpt").Range("C1").Formula _
= "=""Job title: "" & INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))"

You have to double up the quotes within the strings.

Giselle wrote:
>
> Hi XLers
>
> This code fragment works well, resulting in a cell value of, for example,
> Teacher
>
> Worksheets("PrintRpt").Range("C1").Formula =
> "=INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))"
>
> But, I want the cell value to be Job Title: Teacher
>
> I know this should be simple, but I can't get the syntax to work?
>
> TQ for any help
> Giselle

--

Dave Peterson

=" =""Why couldn't "" & ""I"" & ""think of that!"" "
Giselle

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Like:
>
> Worksheets("PrintRpt").Range("C1").Formula _
> = "=""Job title: "" & INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))"
>
> You have to double up the quotes within the strings.
>
> Giselle wrote:
>>
>> Hi XLers
>>
>> This code fragment works well, resulting in a cell value of, for example,
>> Teacher
>>
>> Worksheets("PrintRpt").Range("C1").Formula =
>> "=INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))"
>>
>> But, I want the cell value to be Job Title: Teacher
>>
>> I know this should be simple, but I can't get the syntax to work?
>>
>> TQ for any help
>> Giselle
>
> --
>
> Dave Peterson

because ="=""Giselle "" &"" excel knowledge < Daves excel knowledge "" "
--
paul
remove nospam for email addy!



"Giselle" wrote:

> =" =""Why couldn't "" & ""I"" & ""think of that!"" "
> Giselle
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > Like:
> >
> > Worksheets("PrintRpt").Range("C1").Formula _
> > = "=""Job title: "" & INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))"
> >
> > You have to double up the quotes within the strings.
> >
> > Giselle wrote:
> >>
> >> Hi XLers
> >>
> >> This code fragment works well, resulting in a cell value of, for example,
> >> Teacher
> >>
> >> Worksheets("PrintRpt").Range("C1").Formula =
> >> "=INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))"
> >>
> >> But, I want the cell value to be Job Title: Teacher
> >>
> >> I know this should be simple, but I can't get the syntax to work?
> >>
> >> TQ for any help
> >> Giselle
> >
> > --
> >
> > Dave Peterson
>
>
>

Gawd, those double quotes are confusing!

I sometimes type the formula in a cell, then copy and paste into the code--and
remember to double them up after I paste.

paul wrote:
>
> because ="=""Giselle "" &"" excel knowledge < Daves excel knowledge "" "
> --
> paul
> remove nospam for email addy!
>
> "Giselle" wrote:
>
> > =" =""Why couldn't "" & ""I"" & ""think of that!"" "
> > Giselle
> >
> > "Dave Peterson" <[email protected]> wrote in message
> > news:[email protected]...
> > > Like:
> > >
> > > Worksheets("PrintRpt").Range("C1").Formula _
> > > = "=""Job title: "" & INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))"
> > >
> > > You have to double up the quotes within the strings.
> > >
> > > Giselle wrote:
> > >>
> > >> Hi XLers
> > >>
> > >> This code fragment works well, resulting in a cell value of, for example,
> > >> Teacher
> > >>
> > >> Worksheets("PrintRpt").Range("C1").Formula =
> > >> "=INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))"
> > >>
> > >> But, I want the cell value to be Job Title: Teacher
> > >>
> > >> I know this should be simple, but I can't get the syntax to work?
> > >>
> > >> TQ for any help
> > >> Giselle
> > >
> > > --
> > >
> > > Dave Peterson
> >
> >
> >

--

Dave Peterson