| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Method 'Range' of object '_global' failed | Excel Discussion (Misc queries) | |||
| runtime error 1004 method range of object '_global failed | Excel Discussion (Misc queries) | |||
| Method 'Range' of object '_Global' failed | Excel Programming | |||
| Excel 97 - Clear Method Of Range Object Failed | Excel Programming | |||
| Method 'Range' of object '_Global' failed | Excel Programming | |||
Linear Mode
