IS THERE A IF THEN RULE FOR THE FOLLOWING?.....


Posted by JIM BYRNE on August 15, 2001 11:51 AM

I WANT EXCEL TO LOOK AT A1 CELL AND "IF A1 IS BLANK THEN I WANT C1 TO BE COPIED IN THE A1 FIELD.

IS THERE A COMMAND FOR THIS?? ANY HELP WOULD BE APPRECIATED.

Posted by Aladin Akyurek on August 15, 2001 12:02 PM

No. You'd get a circular reference error.



Posted by Ben O. on August 15, 2001 12:03 PM

You can't do it with a formula (it would be a circular reference) but you can do it with VBA:

For myRow = 1 to 1000
if Cells(myRow, 1).Value = "" Then
Cells(myRow, 1).Value = Cells(myRow, 3).value
End if
Next myRow

Just change 1000 to the last row of your data.

-VF