Deleting the last row

[marcia2026]

I have two worksheets which both have a variable # of rows with a total row
at the end. I have a macro that merges these two worksheets together into
one sheet. Currently, it is including the blank row after the last row of
data and the row with the formula to total Column "F". This is the only info
on this line. When the merge occurs, it includes these two lines from the
first worksheet and this messes up the subsequent code that copies the
formulas in Columns "G" and "H". The formulas stop at the blank row and does
not continue to the last row of data. Also, the total in the middle of the
data is skewing my final total. What code can I include that will delete
these total lines from both worksheets prior to the merge?

thanks bunches

 

[PeterA]

Marc,

Your problem is not particularly hard from the sound of it. Send a copy of the worksheets to enable us grasp what you are describing. "Picture speaks louder than words!"

 

[Bob Phillips]

What code do you have that merges them?

 

[marcia2026]

Bob de Bruin's Merge Sheets to one master. That part works perfectly except
for merging those totals lines