I explain what I want the macro to do in the picture and provide a basic layout of how the sheets are exported from an internet application. I wrote a macro to format the sheets from an unreadable formatting to a user-friendly format. However, I cannot figure out how to change the whole row's cell style due to the text in column B. I have tried using an If Then function, but I haven't found the correct syntax. I greatly appreciate any guidance!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBE Macro to Change Cell Themes in a Row Relative to a String of Text
- Thread starter zfwolfe
- Start date
