Hi there,
So I have an excel table with two collumns where there are writen some numbers.
I need to write in an messagebox, “The row is” number of the row, “and the value is” cell value.
How can I do this?
Can anyone help me?
Thanks
Hi there,
So I have an excel table with two collumns where there are writen some numbers.
I need to write in an messagebox, “The row is” number of the row, “and the value is” cell value.
How can I do this?
Can anyone help me?
Thanks
Also how can I show in a message box only perfect numbers?
Use for each row activity and display the elements using the messagebox.
Thank you! You know how can I write the row and the cell vallue in the msgbox?
Have you used for each row activity?
Hey @Gabriel2,
Cheers
Yes, I solved it. Thanks The next step is to show in the message box only even numbers. Any Ideeas?
I don’t know what to put in the condition of the if to find the odd numbers
Perfect. It worked Thanks!
Now I need to show a msgbox if a number from a cell , from column A is in a cell form collumn B. Any thougths? Filter Data table?
I made a read range for each collumn and I have two data tables : col1 and col2
Now I need to show a msgbox if any number from the col1 is found in col 2
How can I do this?
I made a read range for each collumn and I have two data tables : col1 and col2
Now I need to show a msgbox if any number from the col1 is found in col 2
How can I do this?
If not I need to put a msgb with the message " Does not exist"
I made my modifications and it worked. Thanks!
Happy Automation .
I have another question
So I need to show another msgbox like this:
Col 1: “value first cell” , Col2:“value first cell” Row :“Number Row”
I have variables for each collum in a datatable and used an for each and an if but I don’t know how to make the condition in the if activity and in the message box.
Any ideeas, it will help me alot.
Thanks