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
|