Cannot get macro to paste a formula in specific cells

[Brian.D.Miller]

I'm trying to write a code to place a formula into specific cells based on user input. If I write "= 1" or some other specific value then it pastes into the proper cells no problem but when I ask it to place a formula into those cells I keep getting compile errors. The formula works if I manually place it into the cells so it must be a VBA syntax issue.

For x = 2 To y

cells(x, 1) = "=MATCH(INDIRECT("b"&(ROW()))&"*",MSLD!A:A,0)"

I've double checked that I've closed all parenthesis and quotes a million times. If it helps, when I close the error message it highlights the "b" which I assume is telling me that's where my error lies.

Thanks in advance!

Brian

[martindwilson]

= "=MATCH(INDIRECT(""b""&(ROW()))&"" * "",MSLD!A:A,0)"
mind you shouldnt it be
= "=MATCH(INDIRECT(""b""&ROW())&""*"",msld!A:A,0)" or do you really want a space either side of *

[Brian.D.Miller]

Yes! that worked. thank you. i guess that makes sense, it doesn't know that the beginning quote isn't the end of the previous quote so you have to start and stop every quote before you can start another? i think i get it now, thanks again.