vba formula issue

[PGD15]

Hello!

i'm trying to write a piece of code in VBA but have encountered some issues. below you can see my code.

But the formula doesn't work without the "" around MMM but if i try run the code i get the area as excel is trying end the formula. How do i get around this?

 Worksheets("Source Data").Range("z2").Formula = "=text(z1,[COLOR=#ff0000]"[/COLOR]mmm[COLOR=#ff0000]"[/COLOR])"

 

[Fluff]

You need to double up on the quotes like

.Formula = "=text(Z1,""mmm"")"

 

[PGD15]

I literally feel so dumb! :')

 

[Fluff]

We've all been there

 

[PGD15]

Fluff, my buddy Ole' pal :')

i've just posted this https://www.mrexcel.com/forum/excel-questions/1064767-vba-navigation.html

Is this something you can help with (i just cant figure out how to click on this **** tab on the webpage