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.
Bookmarks