Excel : Select method or Range class failed

[actuaryinworks]

Hi all,
I am using the following syntax in Excel's VBA:

xlWBMe.Sheets(sheetname).range(startletter & startline).Select

where xlWBMe = ActiveWorkbook

The same exact syntax works in another workbook. When I copied it into my current workbook, the 'r' in range became small and Excel gives me the error: Select method or Range class failed

Anybody knows why that happens?

 

[combo]

Try to debug the line. Dim variables and split line. This should allow to find objects you work with:

dim xlWBMe as Workbook
dim xlWks as Worksheet ' more precise than Sheets(x)
dim xlRng as Range

set xlWBMe=Activeworkbook
msgbox xlWBMe.Name
set xlWks=xlWBMw.worksheets(sheetname)
msgbox xlWks.Name
set xlRng=xlWks.Range(startletter & startline)
msgbox xlRng.Address

combo

 

[firefytr]

Are you using a variable named 'range'? Is there a sub/function which shares names? Any missing references?

-----------
Regards,
Zack Barresse