Hi everybody!!!!!
I have a range of cells D11:D30 and I'm trying to write a piece of code that will let me search throught the range and if the word "Parapet" is located in any of the cells then that cell in that same row but column G will be selected and then macro 1 should be called for.
For example
If "Parapet" is found in Range("D22") then
Range("G22").select
call macro1
Thanks for help in advance!!!!!!
I have a range of cells D11:D30 and I'm trying to write a piece of code that will let me search throught the range and if the word "Parapet" is located in any of the cells then that cell in that same row but column G will be selected and then macro 1 should be called for.
For example
If "Parapet" is found in Range("D22") then
Range("G22").select
call macro1
Thanks for help in advance!!!!!!