Excel VBA - Issue in Naming Filtered Range on a Filtered List.

With one cell filtered-out you got problems here:

Please Login or Register  to view this content.

because your Activecell had nothing visible in next rows

Please Login or Register  to view this content.

selected everything from the current cell down to the last row.
could be that oposite direction - the bottom-up could work right

Please Login or Register  to view this content.

but I'd rather go for not selecting, but using already found range:

Please Login or Register  to view this content.

Dear Kaper,

Once again, it's Kaper who has solved my problem!! Brilliant and Efficient

Now that you have helped me group the Names and name the range.

Need you help with Naming entire Grades List.

I can understand that unikaty(i) at each loop will give me each grade.

I presume dane() has the GradesList.

Is it possible to consider the array of values as a Range and Name them?

If so, please help with the code {Would love if it is a few line code}

Need to implement same logic at work on a huge set of data.

Hence the request for efficient-come-few lines code

Thanks,
Vinod Krishna

Hi,

The code works also for large data sets.
Unikaty holds as many (well there are limits of Visual Basic - but for sure not easy to reach with this class of problems) unique grades values as needed.
Try it!
If the data is organised the way it was in the sample file, code would work.

Press F3 and you can get a list of named ranges as they are defined.
Do with these named ranges just what you want (I hope you know what you want - otherwise we both just lost time).

Hi Kaper,

Thank you. I will try based on your suggestion

I think this would be a new requirement and I will raise a new post for the same.

Thanks,
Vinod Krishna