file becomes hang and not responding message shown up

[abdul hayee]

Hi everyone
I want to SUM data of rows of a column. I write a VBA code for that. It works fine for one column. but as long as i addd formula for another column and run it, the application got stuck and not responding message appears.
below is the code

Please Login or Register  to view this content.

excel error.png

what would be the issue and solution? kindly guide me

[dangelor]

Possibly...

Please Login or Register  to view this content.

[abdul hayee]

Thanks dangelor. It is working now
Could you tell me what does this do

Option Explicit

how can i use for loop at this portion because i have more columns to process
Attachment 715513

Thanks

[dangelor]

Option Explicit forces you to declare variables used in the module.

See https://docs.microsoft.com/en-us/off...icit-statement

[dangelor]

...how can i use for loop at this portion because i have more columns to process
Attachment 715513

Thanks

Your attachment could not be opened.

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[abdul hayee]

Hi
@dangelor i have attached a sample file. Some columns are adding the items and showing the result in Total Row. I want to do this to all the items columns using For Loop.
Kindly have a look to the file and guide me

Thanks

[dangelor]

Possibly...

Please Login or Register  to view this content.