excel macro to delete certain cells
1 Topic
Macro to delete certain cells in several columns depending cell value in a different cell
Hello All, In the attached Excel sheet, "Input Continuous-Span Beam" tab, I'd like a macro to do the following when: 1. Cell B10=2, to delete the cells highlighted in yellow for Span#3,4&5 only. 2. When Cell B10=3, to delete the cells highlighted in yellow for Span#4&5 only. 3. When Cell B10=4, to delete the cells highlighted in yellow for Span#5 only. 4. When Cell B10=5, don't delete anything. Also I'd like another macro for deleting cells highlighted in yellow only for LE Cantilever or RE Cantilever or both Cantilevers data which is right at row 60-65. Regards, SamSolved1.4KViews0likes2Comments