software

Hi XLers

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

Worksheets(quot;PrintRptquot;).Range(quot;C1quot;).Formula =
quot;=INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0)) quot;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(quot;PrintRptquot;).Range(quot;C1quot;).Formula _
= quot;=quot;quot;Job title: quot;quot; amp; INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))quot;

You have to double up the quotes within the strings.

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

--

Dave Peterson

=quot; =quot;quot;Why couldn't quot;quot; amp; quot;quot;Iquot;quot; amp; quot;quot;think of that!quot;quot; quot;
Giselle

quot;Dave Petersonquot; gt; wrote in message
...
gt; Like:
gt;
gt; Worksheets(quot;PrintRptquot;).Range(quot;C1quot;).Formula _
gt; = quot;=quot;quot;Job title: quot;quot; amp; INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))quot;
gt;
gt; You have to double up the quotes within the strings.
gt;
gt; Giselle wrote:
gt;gt;
gt;gt; Hi XLers
gt;gt;
gt;gt; This code fragment works well, resulting in a cell value of, for example,
gt;gt; Teacher
gt;gt;
gt;gt; Worksheets(quot;PrintRptquot;).Range(quot;C1quot;).Formula =
gt;gt; quot;=INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0)) quot;
gt;gt;
gt;gt; But, I want the cell value to be Job Title: Teacher
gt;gt;
gt;gt; I know this should be simple, but I can't get the syntax to work?
gt;gt;
gt;gt; TQ for any help
gt;gt; Giselle
gt;
gt; --
gt;
gt; Dave Peterson
because =quot;=quot;quot;Giselle quot;quot; amp;quot;quot; excel knowledge lt; Daves excel knowledge quot;quot; quot;
--
paul
remove nospam for email addy!
quot;Gisellequot; wrote:

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

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:
gt;
gt; because =quot;=quot;quot;Giselle quot;quot; amp;quot;quot; excel knowledge lt; Daves excel knowledge quot;quot; quot;
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt; quot;Gisellequot; wrote:
gt;
gt; gt; =quot; =quot;quot;Why couldn't quot;quot; amp; quot;quot;Iquot;quot; amp; quot;quot;think of that!quot;quot; quot;
gt; gt; Giselle
gt; gt;
gt; gt; quot;Dave Petersonquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Like:
gt; gt; gt;
gt; gt; gt; Worksheets(quot;PrintRptquot;).Range(quot;C1quot;).Formula _
gt; gt; gt; = quot;=quot;quot;Job title: quot;quot; amp; INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0))quot;
gt; gt; gt;
gt; gt; gt; You have to double up the quotes within the strings.
gt; gt; gt;
gt; gt; gt; Giselle wrote:
gt; gt; gt;gt;
gt; gt; gt;gt; Hi XLers
gt; gt; gt;gt;
gt; gt; gt;gt; This code fragment works well, resulting in a cell value of, for example,
gt; gt; gt;gt; Teacher
gt; gt; gt;gt;
gt; gt; gt;gt; Worksheets(quot;PrintRptquot;).Range(quot;C1quot;).Formula =
gt; gt; gt;gt; quot;=INDEX(Job_List!J:J,MATCH(A4,Job_List!A:A,0)) quot;
gt; gt; gt;gt;
gt; gt; gt;gt; But, I want the cell value to be Job Title: Teacher
gt; gt; gt;gt;
gt; gt; gt;gt; I know this should be simple, but I can't get the syntax to work?
gt; gt; gt;gt;
gt; gt; gt;gt; TQ for any help
gt; gt; gt;gt; Giselle
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson