Adding in a ' mark with VBA

[jmzis4me]

So I'm blowing up these forums apparently today. sorry!

So my issue this time around, I am running a macro that when Option A is selected, Option_A is run. That problem was solved, but another arose....

Option_A is suppose to simply:

ActiveCell.Offset(0, 1).Formula = "=INDIRECT(" '"&R[0]C[-5]&"'!E62"))"

basically it's just taking a sheetname that someone puts in a cell 5 left and use that in order to pull off of that sheet name they put in.

Issue is, I can't get past the fact that it thinks I want to put in a note after the ' mark. But I need that mark in there for the correct formula in the cell.

Is this possible?

Thanks!!

[JosephP]

you've gotta double the quotes in the formula string

Please Login or Register  to view this content.

[jmzis4me]

Thanks for that one! The good news is, it's not reading it as a note anymore, but now when I try to run the macro it bugs out with an error "Application-defined or object-defined error" and highlights that row.


any thoughts?

[JosephP]

my bad

Please Login or Register  to view this content.

[jmzis4me]

Awesome, you rule.

Sad part is, I even knew that should have been formulaR1C1 but it didn't hit me.

Thanks!

[JosephP]

you're welcome :-)