praveen7576 Posted November 29, 2007 Report Share Posted November 29, 2007 Hi all, I am running MacroExpress in an Excel file where I have three columns - Department, class, and Item number. The macro copies these values from Excel and looks for the same values in a third-party tool(PRISM) where I have to make some changes for these items(combination of Dept,Class and item number). Now the issue is that if the column 'Dept' has more than 2-digits (for example, 123,345,5679 etc.), then the Macro stops right there and gives an error - saying invalid item combination. I have tried changing the 'if' condition for the dept from <100 to >=1, and it worked for couple of rows, but later it did not accept 3-digit dept number and instead copied the first 2-digits of the dept. I have attached the macro so that you people can have a look and re-attach with the changes needed. Looking forward for a quick and positive reply. thanks. Praveen. Item_Auto_Defective_Flag_ITM380.mex Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.