I want to write a macro to select only range area between 2 words.
For example, I have data about 200-300 rows and I just need only the range that located inside the word "[price]" and "[end_price]" as below:
[product]
a
b
c
[end_product]
[price]
1
2
3
[end_price]
How can I write the vba to run this macro to get answer
1
2
3
In addition, other rows else will be removed by paste only for the selected range
Thank you
For example, I have data about 200-300 rows and I just need only the range that located inside the word "[price]" and "[end_price]" as below:
[product]
a
b
c
[end_product]
[price]
1
2
3
[end_price]
How can I write the vba to run this macro to get answer
1
2
3
In addition, other rows else will be removed by paste only for the selected range
Thank you
Last edited: