Why is my Macro changing cell location to thinking it's text?

[corppunishment11]

=VLOOKUP(M2,BI_ABC_PrvsnP01,2,FALSE)

When I run my macro this one line changes M2 to 'M2'. That's making the formula bomb out and I'm having to manually remove the '

Thanks!

 

[Joe4]

Welcome to the Board!

Please post your macro so we can see what it is doing.

 

[corppunishment11]

Will do! Thank you for the welcome.