Invalid or unqualified reference on range select

**Poulan** · 12-12-2014, 07:50 AM

Can anyone see where this simple as macro went wrong?

Sub Macro1()

ActiveWorkbook.Range(.Cells(12, (2 * 3)), .Cells(14, (2 * 3))).Activate
End Sub

**Kaper** · 12-12-2014, 07:54 AM

dots in front of .Cells

they would be needed in case of

With someobject
  your instruction
end with

**marreco** · 12-12-2014, 07:55 AM

Hi

What do you want to do?

not use .Cells, correct

Cells

and what?

(2 * 3)

**Kaper** · 12-12-2014, 07:57 AM

Originally Posted by marreco

(2 * 3)

This does not hurt. but unqualified dots - as I said - do.

**Poulan** · 12-12-2014, 08:15 AM

Thanks for the comments guys. I tried two options which neither worked:

Sub Macro1()

With ActiveWorkbook
.Range(.Cells(12, (2 * 3)), .Cells(14, (2 * 3))).Activate
End With
    
End Sub

and then this which gave me an 'objcet doesn't supported property or method:

Sub Macro1()

ActiveWorkbook.Range(Cells(12, (2 * 3)), Cells(14, (2 * 3))).Activate
    
End Sub

**Norie** · 12-12-2014, 08:40 AM

A workbook doesn't have a Cells property.

Which worksheet are the cells you want to select on?

**Norie** · 12-12-2014, 08:40 AM

A workbook doesn't have a Cells property.

Which worksheet are the cells you want to select on?

**Poulan** · 12-12-2014, 08:50 AM

They are on the active worksheet.

**Norie** · 12-12-2014, 08:55 AM

Try this.

    With ActiveWorkbook.ActiveSheet
        .Range(.Cells(12, (2 * 3)), .Cells(14, (2 * 3))).Activate
    End With

**Poulan** · 12-12-2014, 09:38 AM

Almost! I would like to select two cells but not the one inbetween that I would like to see not selected.

**Kaper** · 12-12-2014, 01:22 PM

Try:

    With ActiveWorkbook.ActiveSheet
        Union(.Cells(12, (2 * 3)), .Cells(14, (2 * 3))).Activate
    End With

PS. Where were my eyes, that I've not noticed that no sheet was specified few posts up :-(

Re: Invalid or unqualified reference on range select