Timeline for VBA Excel - Conditional Formatting Colour Grab
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 26, 2023 at 19:57 | comment | added | 192927376337929292283737373773 | That isn't simpler, that is much more code. | |
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Jan 26, 2016 at 15:11 | vote | accept | Mr.Burns | ||
| Jan 26, 2016 at 15:10 | vote | accept | Mr.Burns | ||
| Jan 26, 2016 at 15:10 | |||||
| Jan 26, 2016 at 15:06 | comment | added | Mr.Burns |
Thanks for your code I will look at it a bit more, it gives the coloumn letter which is good but seems i will need to learn a bit more about the Cells function for it to work the way I need it to
|
|
| Jan 26, 2016 at 14:34 | comment | added | Raystafarian | Ah, I added something at the end of the answer in case you ever do need to go from number to letter of a column. | |
| Jan 26, 2016 at 14:34 | history | edited | Raystafarian | CC BY-SA 3.0 |
added 388 characters in body
|
| Jan 26, 2016 at 14:21 | comment | added | Mr.Burns |
Thanks for your answer @Raystafarian, i use sCol = Split(ActiveCell.address,"$")(1) as it gives the letter of a column instead of the number and other code I have found to convert it it from number to letter doesnt fit well, least not the ones I found. I am currently updating the code with yours and Zak's suggestion and will put the code up when it is done
|
|
| Jan 26, 2016 at 13:10 | history | answered | Raystafarian | CC BY-SA 3.0 |