Thread: won't select cell on another sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
smit127[_2_] smit127[_2_] is offline
external usenet poster
  
Posts: 1
Default won't select cell on another sheet

I have a large amount of data (over 500,000 rows) so I have spread thi
data over multiple sheets. The code I have written has to find record
that match certain criteria and does this by looping through cells
However, when it reaches the bottom of the first sheet (row 65536)
need it to start on the next sheet but I keep getting a Run time error
Here is the bit of code....

If ActiveCell.Row = 65536 And ActiveSheet.Index < 9 Then
g3000SheetNumber = ActiveSheet.Index + 1
Sheets(g3000SheetNumber ).Activate
Cells(1, 1).Select

It manages to select the new sheet but when I try to select the firs
cell of the sheet it throws an error. Can anyone help please?

--
smit12
-----------------------------------------------------------------------
smit127's Profile: http://www.excelforum.com/member.php...fo&userid=2687
View this thread: http://www.excelforum.com/showthread.php?threadid=40109

Reply With QuoteReply With Quote