Hi,
I thought I had worked this out from google but it seems to not do everything I want.
Formula below works for one string, "review" but i also need it to work for "audit" "project" and "done" too.... so essentially someone can go into the sheet - hit a button and remove all these lines in one go.
Please Login or Register to view this content.
Last edited by pinky24; 03-18-2014 at 11:37 AM. Reason: solved
change this :
to this :Please Login or Register to view this content.
Please Login or Register to view this content.
also read the below.... the modurators frown on these things...... see the forum rules
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:
... and appear like this when posted:Please Login or Register to view this content.
your code here ...
and here ...
and hereYou can also type the code tags in manually if you prefer. For more information about these and other tags, click here.
sorry about that fixed it now!
is there a way to put spaces in? it's throwing up an error and I think it's because the full category is TS Audit, TS Done.
EDIT:
it's coming up with Run-time error '13': Type mismatch
Last edited by pinky24; 03-17-2014 at 05:51 AM.
*bump*
still need help with this
still stuck.... :-(
... anyone....
Try this approach:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks