Dynamic Range for VBA manipulations

I am working on a large macro that is currently working fine with a few spots that have a 'hardwired' range (such as A1:C1000). I originally 'hard-wired' the ranges just to get the macro working for BETA use. I am going back and trying to remove the specific ranges so the macro can find the correct volume of data and the size won't matter. Some of the areas I have changed are working fine, but I am having trouble getting other changes to work.

For example I have changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

, which works fine.

My plot uses

Please Login or Register  to view this content.

which also works.
Selecting my print area also works (I found that function on the forum)

Please Login or Register  to view this content.

also works.
The part that doesn't work: Before the plot section, I have to sort some data. My sort works with the specific range, but I can't get a dynamic range to work. The sort I am trying to use the dynamic range in is:

Please Login or Register  to view this content.

I've tried different versions of the methods used in other sections fo the macro in this last section, but to no avail. The most recent attempt

Please Login or Register  to view this content.

(above) fails at

Please Login or Register  to view this content.

I've been working on this off and on for over two weeks and it is time to ask for help. Please help...

The last time I tried to upload a file, I couldn't, FYI in case you were wondering.

@TM Shucks, thanks! That is shorter.

@nilem, Thank you, that worked in the sopt I had posted. I almost forgot that there is a unique sort that also needs fixed, but I want to see if I can adjust what you've given me on my own (helps me understand better). Still working on it...

Very awesome help!Ya'll rock!

And stuck again. The part that I forgot to include on the first post that needed changed was

Please Login or Register  to view this content.

My attempt that made it the farthest through the code was

Please Login or Register  to view this content.

It hangs up at

Please Login or Register  to view this content.

I was trying to modify the original three level filter to the unique filter. The original script was a recorded macro. When I tried that line with the original

Please Login or Register  to view this content.

It didn't work, hence my above attempt.

I really wanted to figure it out, but I think I have tried everything my (very) limited knowledge can come up with.

In the past I haven't been able to upload attachments other than pictures. (And I never got a response from IT help about it). I just tested it again and a small xcel file worked. So I will see if I can make an example and upload it.

Frack...I have a test file and now it won't let me upload a file again. FYI, the message I get is that a security token is missing.

So, unfortunately, no sample file. I really wish I could...

To sum up what is going on, there are three columns of data per row beginning on row 2. Column A is a system label, column B is a sub-category, and column C is a number formatted as text (so that a 4.10 doesn't get confused with a 4.1). Some rows are identical to other rows, and some are a unique set of data. I need to find the unique rows of data (with all three columns staying with that one 'entry' per row). When I find the unique rows, that is copied to another page and then I re-expand all the data. The next piece of code compares the unique data on the plot tab to the data on the sort tab so it can count how many of a unique set were in the original data. The net result of how many unique sets of each data set is what is plotted on a graph.

Again, I wish I could give an actual test example.

So "missing a security token" actually means "file too large" in my case.

I have attached an excerpt of the workbook that includes the data of concern. I have been able to follow the suggested code thus far. What I can't figure out is why the code is now failing on an Activate command. The main sheet (the real one) works up to the filtUNQCOPY routine. With the old code in filtUNQCOPY, the rest of the routine runs fine.

@snb, I was trying to take out the 'hardwired' range and select the data using a dynamic range. Also, I don't quite follow the previous post using the split....it looks like it is used for manipulating text strings, but I couldn't figure out the connection.

Bump, no response.

@snb, I think I might have figured out what the previous suggest was trying to do. Was your previous suggestion using the split to label the headers and get rid of the Activate that I was using the insert the headers?

I ask because I agree with your signature, I never put code I don't understand onto my computer.

Any thoughts? I can't figure out why a dynamic range selection works for one method and not another. I tried both of the previous suggested methods (which work fine elsewhere in the macro) but could not make either work in this part. Still stumped.

Bump, no response.