Adding Formula

Good Morning. I have a user form, opened from Sheet1, to add data to sheet2 , which works fine. However I would like to sum the cells B:L in column M.
I have the following code but where do I add the reference to sheet2 as the formula is being placed in sheet1. I I just don't seem to be able to get it right.. any help would be appreciated

Lastrow = Range("A65536").End(xlUp).Offset(1, 0).Row
Range("M" & Lastrow) = "=Sum(B1:L" & Lastrow - 1 & ")"

Thank you

Marc

Marc,
Please use code tags with your code.
The code does not have a sheet reference, so it could work in any sheet, just put the cursor in sheet2 and run it, or

Please Login or Register  to view this content.

Sorted it, Thanks for the help