Dynamic Range VBA question

[bc012493]

Hello,

I have a question about programming dynamic ranges in VBA. I have 5 columns with a variety of different input types, including text, date and numbers. At the bottom of the list, I have two cells (separated by two blank rows) that contain subtotal and sum formulas, as well as labels, as a means of checking and filtering the data. I have set up dynamic ranges in my current program with the following code:

Please Login or Register  to view this content.

The problem is that this code includes the subtotal and sum values in the range, and I do not need them to be included. How can I adjust my code to exclude these values and include only the "data"? I have attached a file to help visualize my dilemma.

Thanks for your help.

[HaHoBe]

Hi, bc012493,

welcome to ExcelForum. Please be reminded to use code-tags whenever you post procedures here according to Forum Rule #3.

Maybe use

Please Login or Register  to view this content.

Ciao,
Holger

[bc012493]

Thanks for your response Holger. Unfortunately this change did not produce the desired effect. I realized my original post does not include two "header" rows that exist in the documents I am actually working with. I have attached an updated version of the example file.

Essentially, I am seeking a way to squeeze the dynamic range to be (Row 3:The last Row of data, excluding the subtotal/total calculations)

Thanks

[HaHoBe]

Hi, bc012493,

this is one of the rare cases where you either choose not to work with the last column ij the area as there are additional lines after the area you want to work with or start from the top and go down:

Please Login or Register  to view this content.

Ciao,
Holger

[bc012493]

Holger,

This worked! Thanks so much.

[jolivanes]

You have this already

Please Login or Register  to view this content.

What if you just change it to

Please Login or Register  to view this content.