Hey nice people, I would be really thankful if somebody could help me with this issue:
Is there a way to define a range that consists only of the rows that in some column contain certain data?
Example:
Let's say I have in Column A the categories Cat1 and Cat2
Can I set a range that contains all the rows that have on the column A the text Cat1?
I am sorry I currently have no vba code to post... If I do before i get an answer I am going to post it.
Thanks a lot in advance.
V.
Bookmarks