I want to fill several columns with data if the cell in column B is blank I have managed to do this for one column but am struggling to get it to run for more than one column… So if B is not blank, then complete column K with Customer, complete column P with Allow and complete column Q with Normal (haven’t done as haven’t got P to work yet!)
For Each Cel In Range("B18:B90000")
If Cel.Value <> "" _
Then Cel.Offset(0, 9).Value = "Customer"
'Cel.Offset(0, 5).Value = "Allow"
Next
This helped me to do it for one column: VBA - If a cell in column A is not blank the column B equals This helped me to perform 2 actions but its not working https://www.mrexcel.com/forum/excel-questions/524212-vba-if-statements-can-you-have-multiple-actions-then-area.html If anyone can help, it would be massively appreciated Thanks!
Aucun commentaire:
Enregistrer un commentaire