CBrine
11-27-2006, 12:24 PM
I don't use the find very often programmatically within VBA, but decided to do this with a project I'm working on, since I know it's faster then cycling through cells.
I have a summary with unique values based on 2 columns, which I create in Column A by linking the two other columns together.
A......B......C
12.....1......2
13.....1......3
21.....2......1
etc....
I then hide column A so that it doesn't show up in the column, since I don't want the user to see the unique index I'm using.
The problem occurs when I try and execute a find on the hidden column. It doesn't seem to work?
Has anyone found a way around this, other then unhiding, then re-hiding the column? or am I stuck with it?
Thanks
Cal
I have a summary with unique values based on 2 columns, which I create in Column A by linking the two other columns together.
A......B......C
12.....1......2
13.....1......3
21.....2......1
etc....
I then hide column A so that it doesn't show up in the column, since I don't want the user to see the unique index I'm using.
The problem occurs when I try and execute a find on the hidden column. It doesn't seem to work?
Has anyone found a way around this, other then unhiding, then re-hiding the column? or am I stuck with it?
Thanks
Cal