excel - InStr(1, cell.Value, "-") doesn't seem to be working with Not -

-

i have conditional doesn't seem work.

if not instr(1, cell.value, "-")     'do else     'do else end if

where cell.value either numbers in spreadsheet dash: "6621-123", or without dash: "555321"

the first if let's both through , else ignored. ideas why isn't working?

instr returns 0 on no match (not -1 vba string indexes 1 based) , not 0 true (-1); other possible values > 0 can returned.

if instr(1, cell.value, "-") = 0     '// not present else     '// present

Comments

Post a Comment

Popular posts from this blog

Capture and play voice with Asterisk ARI -

-
there channel ari demo in wich can control channel state: ring, answer, play silence, play tone or audio-file ( https://github.com/asterisk/ari-examples/tree/master/channel-state , https://wiki.asterisk.org/wiki/display/ast/ari+and+channels%3a+manipulating+channel+state ) possible receive chunks (parts, buffers, etc.) of call voice (which created remote subscriber) or write chunks of voice, example array of bytes (not file) in audio format (alaw, ulow etc). you can use asterisk eagi interface voice data. other option use record or mixmonitor app record channel(channel have put stasis allow dialplan control ari) "write chunks of voice" can done application playback also can create own application using c/c++, compile asterisk , result want. no, can't redirect voice directly using ari.
Read more

c - Unrecognised emulation mode: elf_i386 on MinGW32 -

-
i'm trying make kernel, , cannot link c output assembly. ld . i'm getting error: unrecognized emulation mode: elf_i386 i'm using windows 10 professional mingw32 , msys. code using: link.ld /* * link.ld */ output_format(elf32-i386) entry(start) sections { . = 0x100000; .text : { *(.text) } .data : { *(.data) } .bss : { *(.bss) } } kernel.c /* * kernel.c */ void kmain(void) { const char *str = "my first kernel"; char *vidptr = (char*)0xb8000; //video mem begins here. unsigned int = 0; unsigned int j = 0; /* loops clears screen * there 25 lines each of 80 columns; each element takes 2 bytes */ while(j < 80 * 25 * 2) { /* blank character */ vidptr[j] = ' '; /* attribute-byte - light grey on black screen */ vidptr[j+1] = 0x07; j = j + 2; } j = 0; /* loop writes string video memory */ while(str[j] != '\0') { /...
Read more

ios - Debugging Core Data __NSCFSet addObject nil exception -

-
i'm getting exceptions thrown during unit tests, on core data thread message: coredata: error: serious application error. exception caught during core data change processing. bug within observer of nsmanagedobjectcontextobjectsdidchangenotification. -[__nscfset addobject:]: attempt insert nil userinfo (null) *** terminating app due uncaught exception 'nsinvalidargumentexception', reason: '-[__nscfset addobject:]: attempt insert nil' *** first throw call stack: ( 0 corefoundation 0x00683a14 __exceptionpreprocess + 180 1 libobjc.a.dylib 0x02334e02 objc_exception_throw + 50 2 corefoundation 0x0068393d +[nsexception raise:format:] + 141 3 corefoundation 0x005595b9 -[__nscfset addobject:] + 185 4 coredata 0x001d47c0 -[nsmanagedobjectcontext(_nsinternalchangeprocessing) _processpendinginsertions:withdeletions:withupdate...
Read more