satyen
10-13-2011, 04:03 AM
Hello.
I am having trouble figuring out the code to calculate the autosum the above range. There is not set range , row or column as this will change from sheet to sheet.
Please can someone help.
I found this as it similar to what I am looking for- but this looks at the fixed column D. Not what I am looking for.
Sub SumMyRange()
Range("D65536").End(xlUp).Offset(1, 0) = _
"=Sum($D:" & Range("D65536").End(xlUp).Address & ")"
End Sub
Please can someone help. Thank you
I am having trouble figuring out the code to calculate the autosum the above range. There is not set range , row or column as this will change from sheet to sheet.
Please can someone help.
I found this as it similar to what I am looking for- but this looks at the fixed column D. Not what I am looking for.
Sub SumMyRange()
Range("D65536").End(xlUp).Offset(1, 0) = _
"=Sum($D:" & Range("D65536").End(xlUp).Address & ")"
End Sub
Please can someone help. Thank you