Really quickly, is there a way to say in code
IF my activecell has no value (either nothing at all "", or one empty space " " or more empty spaces " "
basically i dont want to encounter a cell that doesnt have a visible value in it
I tried if activecell.value = empty, but that doesnt account for more than one empty character, i want something to account for all possible blank characters or blank strings of any length, thanks!!!
IF my activecell has no value (either nothing at all "", or one empty space " " or more empty spaces " "
basically i dont want to encounter a cell that doesnt have a visible value in it
I tried if activecell.value = empty, but that doesnt account for more than one empty character, i want something to account for all possible blank characters or blank strings of any length, thanks!!!