MonsterBait
New Member
- Joined
- May 17, 2012
- Messages
- 10
Hi All,
I wrote a bit of code that's been working great until now. The Records have reached over 1100 entries and my code doesn't do what I designed it for anymore.
I just need the segment of code to locate a record number in column "A" and make that the active cell.
The offending code (which I wrote and had been working probably for the wrong reasons) is:
Dim CurCell as Range
num2 = Range("UpdateNumber")
Set CurCell = WorkBooks("Database.xlsx").Sheets("Records").Range("$A$2:$A$2000").Cells(num2)
[additional code here which updates the record]
**UpdateNumber is a named range which holds a record number the user has input.
**Some records have been deleted and all blank/empty rows have been removed.
**The first 2 rows of the database are title/headings
Scaled down sample database:
<TBODY>
</TBODY>
I would be very grateful if someone could point out what I'm doing wrong and hopefully suggest a solution.
Thanks,
Alex
I wrote a bit of code that's been working great until now. The Records have reached over 1100 entries and my code doesn't do what I designed it for anymore.
I just need the segment of code to locate a record number in column "A" and make that the active cell.
The offending code (which I wrote and had been working probably for the wrong reasons) is:
Dim CurCell as Range
num2 = Range("UpdateNumber")
Set CurCell = WorkBooks("Database.xlsx").Sheets("Records").Range("$A$2:$A$2000").Cells(num2)
[additional code here which updates the record]
**UpdateNumber is a named range which holds a record number the user has input.
**Some records have been deleted and all blank/empty rows have been removed.
**The first 2 rows of the database are title/headings
Scaled down sample database:
Title | |||
Record Number | Name | Description | Date |
1 | Tom | Test Alpha | 1/04/2011 |
2 | **** | Test Bravo | 4/06/2011 |
6 | Harry | Test Charlie | 7/08/2011 |
7 | Vicki | Test Delta | 16/08/2011 |
8 | Heather | Test Echo | 2/01/2012 |
<TBODY>
</TBODY>
I would be very grateful if someone could point out what I'm doing wrong and hopefully suggest a solution.
Thanks,
Alex