Hello,
I am trying to test the contents of a cell as to weather it contains an "X" or not with an if statement.
At the "If" line I get error 400???
here is the code:
See attachment
Thanks so much for your help
RN
Hello,
I am trying to test the contents of a cell as to weather it contains an "X" or not with an if statement.
At the "If" line I get error 400???
here is the code:
See attachment
Thanks so much for your help
RN
Last edited by RustyNail; 02-19-2018 at 01:04 PM.
=if( cell = "X" , "contains X", "does not contain X")
where cell is the address of the cell you want to test
ie A2 , B3 etc
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
Assming you want to see if x occurs in a string of several characters then maybe as a function
=IF(ISERROR(SEARCH("x",A1)),"","Y")
You can post code or functions. Just click the # or fx icons above the post area to wrap your code/function in the approriate tags.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
This is frustrating ... the site won't allow me to post sample code
You can view the code text file to see exactly what I am trying to do!!
Thank you so much for your help
Last edited by RustyNail; 02-19-2018 at 01:08 PM.
oh, OK VBA - not my area, should be in VBA forum really
I'm sure Richard Buttrey , will move
I need to put the if statement in a for loop so I need the numbers of the rows...
Please view my attachment in the initial post !!!
Thanks
oh, OK VBA - not my area, should be in VBA forum really
I'm sure Richard Buttrey , will move
using the >>>>>>> is being seen as HTML code tag
Please Login or Register to view this content.
Ok I had the column and row inverted ....
Solved!
PS can someone tell me how to mark this thread as solved?
Thank you
...and hadn't put the "A" in literals.
That said why is the macro always selecting the same two B6 & E10 cells wherever an x occurs. It's not at all obvious what a loop is achieving.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks