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
Bookmarks