VBA if formula to cell

**Evolta** · 11-21-2013, 07:05 AM

Hello,

Got a little problem here;

Please Login or Register  to view this content.

ws. = data sheet
iRow = first empty row

Cells(iRow, 14) is cell to match ""
options "nee" and "ja" are text, so must be in quotations.

Also tried this;

Please Login or Register  to view this content.

no luck with this either

**Olly** · 11-21-2013, 07:14 AM

Try:

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 11-21-2013, 07:17 AM

Try:

Please Login or Register  to view this content.

**Evolta** · 11-21-2013, 07:24 AM

I tried yours John and it didn't work.
The second one from OllyXLS did. (first one I have not even tried, so that might work too, dunno)

Thanks both for the fast reply!