Microsoft Office Forums - View Single Post - IF adjacent cell empty Copy from Other Column

Thread: IF adjacent cell empty Copy from Other Column

View Single Post

Old

03-08-2018, 05:31 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Sorry Chris, should have given you a little more.

Code:

If Cells(i, 9).Value <> ""

There is no need for the equal sign as <> is the operator

Reply With Quote