I have a button that generates an answer key for a test. The answer key does not contain the question just the answer. Currently the code adjusts the row height to the original row height of the question, which makes the answer key look ridiculous and take up a lot of paper. Is there a VBA to check whether a cell contains a picture, and if not then run an autofit code?
-
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.
VBA to Autofit Row height for cells that do NOT contain a picture?
- Thread starter ShoYnn
- Start date
