How do I highlight a row containing certain key words

3wits
3wits used Ask the Experts™
on
I have attached my spreadsheet for reference.  I have a common spreadsheet with formulas.  It contains a macro that 1)removes totals; 2)set filter; 3)sort A; 4)sort C highest to lowest; 5)add subtotals: and last 6)remove filter.  Crtl-t is used to activate the macro.

This is what I still want to do.  Highlight the subtotal rows (or columns A-P) AND insert a blank line under the subtotals.

Can you help?
test--8-5-11.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
check this one
test--8-5-11.xlsm
IT Director
Commented:
The attached file has the new code added to your cub routine and has been tested.
Copy-of-test--8-5-11-1-.xlsm
Commented:
this will work fine
test--8-5-11.xlsm
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Author

Commented:
I've requested that this question be deleted for the following reason:

found my solution

Author

Commented:
I found my solution
JPIT Director

Commented:
I dont agree that the question should be able to be removed after a working solution has been provided.
JPIT Director

Commented:
I dont agree that the question should be able to be removed after a working solution has been provided.
The first comment addresses only one of the two requirements.

The second and third comments each address both comments.
Points may be split between #36321455 and #36321492
JPIT Director

Commented:
Why split the points if the second addresses both concerns and the third was submitted over 20I minutes later.
Splits are done with even larger time gaps.

Besides the two which address both issues do so in different ways. Any one may be preferred over the other. The OP is the best judge for the choice. That is why I suggested a split.

Author

Commented:
I'm sorry for the problems this has caused.  I just registed for this site 2 days ago and I guess I was not aware of how it worked.  I actually deleted the question because I received the answer on another question from dlmille that also answered this question.  However, it was a separate question. You are correct, the first comment only answered part of the question and the 2nd and 3rd answered completly.  I will make sure I do things correctly the next time.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial