Highlight data set of variable size

[DukeRollo]

Good morning. My apologies if this was already covered and I missed it.

In my job, I have a report I get each day. The columns are always the same, but the rows are variable. They can be anywhere from 300 to 3000 (or more in extreme cases).

I am looking to create a Macro that creates pivot tables out of the data. I've almost got it, but I admit I am a novice at VBA. So the question:

How do I, using VBA, get Excel to select just the number of rows in the data set when that number varies from day to day?

Each time I try using the record macro feature, Excel gives me specific cell references and that's no good.

Thank you for taking the time to read. Know that your responses are appreciated.

Thank you.

[davesexcel]

Set a variable range

Please Login or Register  to view this content.

[DukeRollo]

Set a variable range

Please Login or Register  to view this content.

Good morning, Dave. (totally reading that in a Hal 9000 voice... *ahem* moving on)

Thank you for your speedy reply. I have no doubt that what you posted is exactly what I need. However, I am still a novice. Can you give me a breakdown, please? I very much want to understand the code rather than just copy/paste it into a macro.

Thanks again.

[davesexcel]

Sure thing, lets see your code, then we can edit it to work with the lines of code I provided, that finds the last row in column A and sets the range

[DukeRollo]

Sure thing, lets see your code, then we can edit it to work with the lines of code I provided, that finds the last row in column A and sets the range

I very much appreciate your offer. And I fully understand that things in Excel are not copyrighted or anything like it. But my company frowns on things getting copied and pasted on the internet. I know... I know... it's just code. But it's not worth the risk.

I will completely understand if you're disinclined to continue the explanation.

[davesexcel]

The information you have supplied is insufficient, I can only assume. The code I gave you finds the last row in column A and then sets the range from (A1:C and last row). Nothing more I can give you until you have supplied more information.
If you are using your macro recorder, check out relative and absolute references to find the last row.

Check out my site on selection codes as well.
http://www.xlorate.com/selection-codes.html