I don't know VBA and asking for help on learning VBA to write a formula in column C if the cell in column A is not empty.
I have attached a workbook with the formula and the way I am using now is to put the formula in more cells than the user will use.
The user may add comments to explain what they want done by the people doing the work and each row doesn't need a formula based on the contents of column A.
I thought about using a Table format but it doesn't copy the formula if there user adds a blank line above.
Can VBA apply row formatting?
Any help is appreciated.
Thank you.
I have attached a workbook with the formula and the way I am using now is to put the formula in more cells than the user will use.
The user may add comments to explain what they want done by the people doing the work and each row doesn't need a formula based on the contents of column A.
I thought about using a Table format but it doesn't copy the formula if there user adds a blank line above.
Can VBA apply row formatting?
Any help is appreciated.
Thank you.
Attachments

251.7 KB Views: 2