Editing a module for detect certain characters
Hi there,
I have this code
This works perfectly. It looks for the characters and fills the cell with the corresponding text. However, when the cell is blank OR does not contain any of the characters, it fills with "textiles". Can we please find a way for the cell to just be left blank instead of defaulting to "textiles".
Please Login or Register to view this content.
Does this make sense?
Thank you.
What do you actually have in the cells you are using this function on?
I ask because it's not actually the value in the cell you are checking in the code.
You appear to be splitting the value passed to the function using '.' as a delimiter and then checking the 3 element of the resultant array.
If you passed a blank cell or empty string that would immediately cause problems.
I suppose you could deal with empty cells like this.
Please Login or Register to view this content.
Last edited by Norie; 05-17-2017 at 12:04 PM.
If posting code please use code tags, see here.
The cells it is checking look like:
HDN.J.TB.20.1
HDN.J.TB.20.2
HDN.B.TB.15.1
HDN.B.TB.15.2
HBD.B.BE.1.2
HBD.B.BE.1.1
etc..
The code posted gives me the #VALUE! in the blank cells
The code I posted will return an empty string if the cell passed to it is empty or contains an empty string.
Ah yep. You are right. Now, I do have some cells that have a 0 in them, can we check this and then return an empty cell too?
Try this.
Please Login or Register to view this content.
This worked the best ever. Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks