Hi folks
i know the forumla, using left and find to get the value of a cell to the left of the first space. (i.e if the cell said http://www.ozgrid.com click here then im looking for just http://www.ozgrid.com)
however, when I try and use this in vba I cant get it to "find".
Does anyone have any tips?
PS im trying to get the value of a textbox, before the first space
Many Thanks
Jamie