ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro -find all occurences of a word-change color of cell of all (https://www.excelbanter.com/excel-programming/350563-macro-find-all-occurences-word-change-color-cell-all.html)

Lost in Alabama

macro -find all occurences of a word-change color of cell of all
 
I need help!

I need a macro to find all occurences of the word "Count" in Column B, and
then change the fill color for all the cells located to Yellow.

Could someone help me with the proper procedure to do this.

Thanks,



Norman Jones

macro -find all occurences of a word-change color of cell of all
 
Hi Lost in Alabama,

See the example given in VBA help for the FindNext method.


---
Regards,
Norman



"Lost in Alabama" wrote in message
...
I need help!

I need a macro to find all occurences of the word "Count" in Column B, and
then change the fill color for all the cells located to Yellow.

Could someone help me with the proper procedure to do this.

Thanks,





Lost in Alabama

macro -find all occurences of a word-change color of cell of a
 
Hello....This is your Sign!! Thank you so much for the help and I pray you
have a Blessed Year!

Lost in Alabama

"Norman Jones" wrote:

Hi Lost in Alabama,

See the example given in VBA help for the FindNext method.


---
Regards,
Norman



"Lost in Alabama" wrote in message
...
I need help!

I need a macro to find all occurences of the word "Count" in Column B, and
then change the fill color for all the cells located to Yellow.

Could someone help me with the proper procedure to do this.

Thanks,







All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com