Forum Discussion

kevinduque's avatar
kevinduque
Brass Contributor
Jan 15, 2020
Solved

Convert colored filled cells to numbers

Hi Team,   so i have tables below and I want assigned cells filled with color red, yellow, and white converted to corresponding numbers. any idea or help is very  muchappreciaTED   Red 1 Y...
excel
Macros and VBA
  • PascalKTeam's avatar
    PascalKTeam
    Jan 15, 2020
    My pleasure
    The steps you have to perform are the following
    1. Open my file (the one which contains the macro)
    2. Open the VBA editor (Alt+F11)
    3. Navigate to sheet1
    4. copy the entire code you see
    5. Open your file
    6. Open the VBA editor (Alt+F11)
    7. Select the sheet in which you want the code to run (yes, the code will only run in this sheet)
    8. paste the code into the VBA editor
    9. test, save and hopefully be happy with it 🙂

PascalKTeam's avatar
PascalKTeam
Iron Contributor
Jan 22, 2020
I would need more information to find out the reason for the problem...
Can you post the file?
kevinduque's avatar
kevinduque
Brass Contributor
Jan 22, 2020

PascalKTeam its all good now thank you i restarfted my laptop and it worked thank you... can you help me with my other qeuries?

  • PascalKTeam's avatar
    PascalKTeam
    Iron Contributor
    Jan 22, 2020
    OK good.
    Yes i can but we should not use this topic
    You can send a private message to me if you want

Resources