Hi,
New to VBA here, getting error 424 object not found with this code after running, it runs only once perfectly but stops after 1 iteration. Consider "yyy" as all different variables (code I am using is below).
Any help would be appreciated
<tbody>
</tbody>
Thanks in advance
New to VBA here, getting error 424 object not found with this code after running, it runs only once perfectly but stops after 1 iteration. Consider "yyy" as all different variables (code I am using is below).
Any help would be appreciated
Sub DeleteSpecifcColumn() Set MR = Range("A2:BT2") For Each cell In MR If cell.Value = "yyy" Then cell.EntireColumn.Delete If cell.Value = "yyy" Then cell.EntireColumn.Delete If cell.Value = "yyy" Then cell.EntireColumn.Delete If cell.Value = "yyy" Then cell.EntireColumn.Delete Next End Sub |
<tbody>
</tbody>
Thanks in advance