I have tried to add a variable to an index & match worksheet function in vba without success as shown below.
The variable is mat_ox
![]()
Please Login or Register to view this content.
Any assistance would be greatly appreciated.
Thank you
I have tried to add a variable to an index & match worksheet function in vba without success as shown below.
The variable is mat_ox
![]()
Please Login or Register to view this content.
Any assistance would be greatly appreciated.
Thank you
Have you tried:
![]()
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you for your assistance
I have now just tried your recommedation and it did not work. However, vba return "invaild character" error.
Can I see the entire code and maybe a sample worksheet?
Thank you for your prompt reply.
Here is a copy of the code.
It is in the early stages of development!
Essentialy I want to validate data in a worksheet against reference data (defined upper and lower limits) in another spreadsheet.
For example a record with a "mat_ox" value of "blabla" would have defined upper and lower limits for each measure eg copper (Cu) Uranium (U) and Specific Gravity (SG). The macro tests each value aganst the data in Ref_Table spreadsheet and if the value is outside the upper and lower limits the cell is flagged (infilled red).
![]()
Please Login or Register to view this content.
here is the ws
Hi prestopr,
I've altered your code but am unable to test the coloring aspect since I'm using 2003 and it protests against the "too many formats" in your sample - let me know if it works for you:
![]()
Please Login or Register to view this content.
Last edited by xladept; 02-07-2013 at 04:02 PM.
mat_ox is a string so you must enclose the value in quotes
![]()
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Hi prestopr,
It works with Joseph P's code up to where the coloring starts if you do it this way:
![]()
Please Login or Register to view this content.
yeah-there's no match for mat_ox in that table :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks