Hi,

I am new to macro,

Can anyone tell me what's wrong with the code below?
I need to get sum for every week.ie, this week is sum for week1 to week5, next time it will be week 1 to week6.
However the last line of the code doesn't give me the sum.

Dim m_copycell As String
Sheets("SHEETA").Select
Range("L5").Select
m_copycell = Range("L5").Value
Range("F4").Select
Cells("F4").Formula = "=SUM(B2:m_coypcell")"

Thanks a lot.