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
|