Add Column Cell Values Within Range Selection. Delete Rows

**Ray Storm** · 08-12-2015, 05:23 PM

Hi everyone,

I am trying to create a quick vba macro that will allow a user to make a row selection ( Rows("2:5").Select ) and sum column D and column E independently. I then tried to add a For loop to delete excess rows. I seem to have encountered some trouble with parts of the vba, and I would be grateful for any suggestions. Thank you!

Ray

Test.xlsm

Please Login or Register  to view this content.

**daffodil11** · 08-12-2015, 07:26 PM

I went with:

Please Login or Register  to view this content.

When deleting it's usually best to start at the bottom and move up. This is because when you delete a given cell, the cells below it move up and then you skip the row that replaced it.

By moving up you avoid this issue.

**Ray Storm** · 08-12-2015, 07:42 PM

Thank you for teaching me

Add Column Cell Values Within Range Selection. Delete Rows

LinkBack

Thread Tools

Rate This Thread

Display

Add Column Cell Values Within Range Selection. Delete Rows

Re: Add Column Cell Values Within Range Selection. Delete Rows

Re: Add Column Cell Values Within Range Selection. Delete Rows

Thread Information

Users Browsing this Thread

Similar Threads

Delete rows based on values in a column

Delete rows where column A has duplicates based on values in Column B

Macro to delete entire rows if cell values do not match list/named range.

Scan rows for duplicate column values, then add rows together and delete unused rows.

Delete Rows based on Values in a column

Delete Rows If A Column Contains One Of Several Values

macro to delete rows with a range for values

Delete rows with specific column values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions