Delete columns & Row based on criteria VBA code needed

[Gary B]

I need to have a Macro that will delete a row if the cell value is less than 11 and also delete column if the names are Provider,Mngd balance, Hold Status, K?,Enrollment Date. This needs to Delete Rows & Columns.jpg

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Vikas_Gautam]

For deleting rows...

Try this..

Please Login or Register  to view this content.

Don't forget to click *

[Vikas_Gautam]

after that try this for deleting columns..

Please Login or Register  to view this content.

Don't forget to click *

[Gary B]

Hi John,
The code works. Now I need to have it work on the other 8 sheets in the workbook. Thanks for the help!!!

[JOHN H. DAVIS]

You're welcome. Does this help for the other worksheets?

Please Login or Register  to view this content.

[Vikas_Gautam]

Try this..
Garys code revised....

Please Login or Register  to view this content.

Don't forget to click *

[Gary B]

Hi John,
This works on all sheets except it doesn't remove the columns with Hold Status in column 8 and Enrolment Date in column 12 for some reason.
Column 3 Provider, Column 6 Mngd balance and column 10 K? work fine. Any idea's ?
Gary B

[JOHN H. DAVIS]

Well for Column 12, how do you spell Enrollment Date? Check for spelling and leading and trailing spaces in your headers.

[Gary B]

I seplled Enrollment on the workbook correctly and it's correct in the code.

[Gary B]

Sorry, I mean I spelled Enrollment correctly, no leading spaces or trailing spaces.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.