replacing all alphabet column refs with numbers in any
place where you have used the Cells thingy.
The line with "W" in it also has a missplaced bracket, same as above.
Regards - Dave.
> Date: Mon, 5 Jan 2009 17:24:35 -0800
> Subject: $$Excel-Macros$$ Re: Validating a column of numb
Tiwary
To: excel-macros@googlegroups.com
Sent: Tuesday, 6 January, 2009 10:28:16 AM
Subject: $$Excel-Macros$$ Re: Validating a column of numbers against another
worksheet
go to tools - > options -> calculation and
, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
From: Rob Bunocore
To: MS EXCEL AND VBA MACROS
Sent: Tuesday, 6 January, 2009 6:54:35 AM
Subject: $$Excel-Macr
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
Hi Rob,
This problem is better solved with conditional formatting.
Select all the valid ICD9 codes on the second sheet, and name the range - let's
say, List
Then on 1st sheet, select all the cells you want to check, and any blank cells
that might have codes entered into them later.
Select Format
