Method Range of object global failed
 

I have an error message as per subject. I've just changed from Excel 2000
to Excel 2003 and I don't get a popup tip?? to show the value of my
variable.
Formula on sheet is Range("E1") = COUNTBLANK(Comp!RC[1]:R[25]C[1])+1

Code that breaks down:

Dim Cb As Integer 'Where the players
list starts
Cb = Sheets("Print").Range("E1")
Sheets("Comp").Select
Range(Cells(Cb, 8)).Select 'Top player H Row

Guidance appreciated.
Dennis

Method Range of object global failed
 

Range(Cells(Cb, 8)).Select

should just be

Cells(Cb, 8).Select

--
Regards,
Tom Ogilvy


"Dennis" wrote in message
...
I have an error message as per subject. I've just changed from Excel 2000
to Excel 2003 and I don't get a popup tip?? to show the value of my
variable.
Formula on sheet is Range("E1") = COUNTBLANK(Comp!RC[1]:R[25]C[1])+1

Code that breaks down:

Dim Cb As Integer 'Where the players
list starts
Cb = Sheets("Print").Range("E1")
Sheets("Comp").Select
Range(Cells(Cb, 8)).Select 'Top player H Row

Guidance appreciated.
Dennis

Method Range of object global failed
 

Thanks for the fast reply Tom
Dennis
"Tom Ogilvy" wrote in message
...
Range(Cells(Cb, 8)).Select

should just be

Cells(Cb, 8).Select

--
Regards,
Tom Ogilvy


"Dennis" wrote in message
...
I have an error message as per subject. I've just changed from Excel
2000
to Excel 2003 and I don't get a popup tip?? to show the value of my
variable.
Formula on sheet is Range("E1") = COUNTBLANK(Comp!RC[1]:R[25]C[1])+1

Code that breaks down:

Dim Cb As Integer 'Where the
players
list starts
Cb = Sheets("Print").Range("E1")
Sheets("Comp").Select
Range(Cells(Cb, 8)).Select 'Top player H Row

Guidance appreciated.
Dennis