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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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