VBA Code to SUM range on Specified Worksheets

[AnkitJain]

Hi All,

I need a code which can help me to sum the data in a column in a specified sheet and give result in a another worksheet. Suppose i want to sum a range from A1 to A50 (which can very every time) on sheet 1 and need the result on Sheet 2 in range "B1"

Can anyone help me please.

Thanks,
Ankit Jain

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Or:

Please Login or Register  to view this content.

[AnkitJain]

Thanks John.. Its working now.. Will post again if face any difficulty further..

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rules and mark this thread as SOLVED. Refer too link below for guidance.

http://www.excelforum.com/forum-rule...rum-rules.html