I've used the following code in Excel XP with no problems.
Now that I have Excel 2007, I keep getting an "Overflow" error when trying to run the code. Sometimes it will say "Runtime error '6':, Overflow"
When I step through the code (F8) the line that brings up the error is:
If N > Cells.Count Then GoTo DataError
To give an example of what values I'm entering use the following:
Cell A1 = c
Cell A2 = 5
Cells A3 - A17 = A-O (one letter per cell)
Any help would be greatly appreciated.
![]()
Please Login or Register to view this content.
Bookmarks