Get specific range from closed workbook depending on row value

Hi,

Thank you for reading this.
This forum is great and I have tried searching for topics with similar problems but without any luck. So here's my question?

How can I get a specific range from a closed workbook depending on which row a specific value appears?

I use the following code to get static ranges. But from now on the rows of these ranges will change from day to day.

Please Login or Register  to view this content.

So is there an easy way to set the ranges depending on where a specific row value appears for column A (the value will not change, only their row).

Example:
A, B
1: gar 106000, 400
2: gbr 106000, 300
3: gbr 106000, 100
4: Total: EUR, 800
5:
6: bbr 109000, 100
7: bbr 109000, 100
8: Total: GBP, 200
9:
10: abr 102000, 500
11: abr 102000, 100
12: Total: USD, 600

So from this I would like the row number of the ranges to be set where the "Total: EUR", "Total GBP", "Total: USD". So in this case: (B4, B8; B12).

Thank you.

Found a solution to my problem:

http://msdn.microsoft.com/en-us/libr.../ff839746.aspx