VBA help!
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
Hello, I am successfully using the following under Excel 2000: Worksheets("Search_Results").Range("A3:AU310").Clear Unfortunately, this call fails in Excel 97. The error is 1004. Also the following line of code fails in 97 and runs perfectly under Excel 2000: Cells(i, k).Copy Destination:=Worksheets("Search_Results").Cells(m, k) Please help! Thank you in advance... "Needless redundancy is the hobgoblin of software engineering." - Peter Darnell