Forum Discussion
kevinduque
Jan 15, 2020Brass Contributor
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...
- Jan 15, 2020My 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 🙂
kevinduque
Jan 22, 2020Brass Contributor
PascalKTeam Hi -
I did use the code to diff file woudl oyu know why its not working? theres no error message but for some reason its not working
PascalKTeam
Jan 22, 2020Iron Contributor
Have you adjusted the code for your columns as explained above?
- PascalKTeamJan 22, 2020Iron ContributorOK good.
Yes i can but we should not use this topic
You can send a private message to me if you want - kevinduqueJan 22, 2020Brass Contributor
PascalKTeam its all good now thank you i restarfted my laptop and it worked thank you... can you help me with my other qeuries?
- PascalKTeamJan 22, 2020Iron ContributorI would need more information to find out the reason for the problem...
Can you post the file? - kevinduqueJan 22, 2020Brass Contributor
PascalKTeam yes so basically I have two diff file name but the same source both file only have two sheets so the first one just perfectly working but the other one for some reason its not running...