High select Column A-I untill A coulumn has Specific Data

Hi My dear Friend,

After long time i post new tread to forum.

I need to know Is there any possibility to select column A-I untill A column appear denial Total.

For more ...

I have spread sheet mention some details.
I want to highlight A-I column untill botom part of "A" column appear "Denied Claims Total:"

For more clarification I had attached the spread sheet which I need to write a macro.

I really appreciate your kind attention and a solution.

Thannks,
Harsha