Hello people,
I think I have a pretty dumb question but I can't figure it out.
I want to know why this works
Sheets("Template").Range("C37").Value = "=VLOOKUP(C36,RA!A2:B100,2,FALSE)"
and this doesn't
Sheets("Template").Range("C99").Value = "=LEFT(C4,FIND(" ",C4)-1)"
I guess it's because of the "" , but that's what has to go into the cell for the rest to work.
How should I phrase that?.
Again, in cell C99 I want the script to write this
=LEFT(C4,FIND(" ",C4)-1)
Thanks in advance.
Cheers!
I think I have a pretty dumb question but I can't figure it out.
I want to know why this works
Sheets("Template").Range("C37").Value = "=VLOOKUP(C36,RA!A2:B100,2,FALSE)"
and this doesn't
Sheets("Template").Range("C99").Value = "=LEFT(C4,FIND(" ",C4)-1)"
I guess it's because of the "" , but that's what has to go into the cell for the rest to work.
How should I phrase that?.
Again, in cell C99 I want the script to write this
=LEFT(C4,FIND(" ",C4)-1)
Thanks in advance.
Cheers!