find last row in column

M

Mike Milmoe

I have data that is consolidated in columns (up to 15 columns). I want to
put a total at the end of the rows, which is not a problem. What I need
however is to delete the columns that don't get used (say if they only
consolidate 10 columns). I know there is a way to find last cell of data for
a column, but is their the same functionality to find the last cell in rows?

Thanks!

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif wrong in last row or two 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
VBA - retrieve data on last create named range from previous inserted named range 0
counting blank cells within two columns 2
Getting Text data using the Data - Subtotal feature 1
Excel Subtracting multiple columns from another column 3
Find last row with data 3
Changing position of last used cell 4

Top