Code to delete all blank rows and add totals

**fusion007** · 06-24-2011, 09:58 AM

Hi...I'm not sure how easy this is but I have a template where data is copied to from another worksheet once calculations have been carried out.
On this template there will be blank rows with no data in them as the number of rows could vary each time.
I would like a code please do delete all the blank rows except the last row which has some calculations.
I would also like to add totals to columns I and J.
The data will start from Column/Row C17.

Can anyone help with a code please?

Thanks

**watersev** · 06-24-2011, 10:41 AM

hi, please post sample workbook showing original data and result you need to get

**fusion007** · 06-24-2011, 11:21 AM

Hi...please find attached sample workbook. You will see from the worksheet that I want to delete all rows between 31 and 121 but keep row 122 and add totals to columns I and J.
Thanks

**watersev** · 06-24-2011, 02:39 PM

please check attachment, run code "test"

**fusion007** · 06-24-2011, 02:51 PM

Works!!! Brilliant thanks so much. Will add reputation points for you.
If you don't mind can you please explain to me how the code works for my future reference.

**watersev** · 06-24-2011, 03:11 PM

Please Login or Register  to view this content.

**fusion007** · 06-24-2011, 04:00 PM

Thanks watersev!

Code to delete all blank rows and add totals

LinkBack

Thread Tools

Rate This Thread

Display

Code to delete all blank rows and add totals

Re: Code to delete all blank rows and add totals

Re: Code to delete all blank rows and add totals

Re: Code to delete all blank rows and add totals

Re: Code to delete all blank rows and add totals

Re: Code to delete all blank rows and add totals

Re: Code to delete all blank rows and add totals

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions