$$Excel-Macros$$ help define a variable as text

I have a macro that loops through a range of cells. It takes the text in the cell, determines the appropriate validation group (a range of cells on another spreadsheet) and compares it to that range. If it finds the value, it changes the color to blue, if it doesn't find the value in the list, t

$$Excel-Macros$$ Re: Validating a column of numbers against another worksheet

Dave: Thanks for your response. I tried this solution but ran into performance issues. There are 10 columns that hold values and sometimes hundreds of rows of data. There are also approx. 20,000 valid ICD9 codes that this is validating against. Moving around the spreadsheet caused serious dela

$$Excel-Macros$$ Validating a column of numbers against another worksheet

I have a list of Diagnosis codes entered into 5 columns on a worksheet. The second worksheet, named ICD9 Codes, lists all the possible ICD9 Codes that are valid. I want to create a macro that you could activate at the top of a column and it would validate each number against the list in the seco

$$Excel-Macros$$ Validating a range of cells

I have a list of Diagnosis codes entered into 5 columns on a worksheet. The second worksheet, named ICD9 Codes, lists all the possible ICD9 Codes that are valid. I want to create a macro that you could activate at the top of a column and it would validate each number against the list in the seco