Method Range of object global failed

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

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
 
Thanks for the fast reply Tom
Dennis
Tom Ogilvy said:
Range(Cells(Cb, 8)).Select

should just be

Cells(Cb, 8).Select

--
Regards,
Tom Ogilvy


Dennis said:
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
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"run-time error '1004' - select method of range failed" 2
Reformat phone to numbers 3
method 'range' of object '_global' failed 2
How do I add the ability to select the number of printed pages to aDialog Sheet 2
Sort and align 2 ranges 1
Select method of Range class failed 4
Advanced Filter works in recorder but not while running macro 5
Different Results from the Same Macro 2

Back
Top