Jagdev Singh
Active Member
Hi Experts
I am trying to find the sum of dynamic range in column C with the below code. But I am getting runtime error 1004 – Application Defined or Object-defined error msg.
Range("C65536").End(xlUp).Offset(1, 0) = "=Sum($C:" & Range("C65536").End(xlUp).Address & ")"
Please let me know what I am doing wrong here.
Regards,
JD
I am trying to find the sum of dynamic range in column C with the below code. But I am getting runtime error 1004 – Application Defined or Object-defined error msg.
Range("C65536").End(xlUp).Offset(1, 0) = "=Sum($C:" & Range("C65536").End(xlUp).Address & ")"
Please let me know what I am doing wrong here.
Regards,
JD