Select method of Range class failed

[WallisAggie646777]

I did a record macro to copy a range of cells from one worksheet and paste into another worksheet which worked when recording the macro with my keystrokes.
When I put the code generated from the run macro into my code and try to execute it, and get the Select method of Range class failed error message. The code that fails is shown below.
There are no merged cells.
Sheets("Groups").Select
Range("O7:T32").Select 'THE ERROR OCCURS ON THIS LINE OF CODE
Application.CutCopyMode = False
Selection.Copy
Sheets("Temp").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Selection.Copy

 

[Joe4]

Welcome to the Board!

Do you have any hidden rows or columns, or any protection going on?
Other than merged cells, those are the only other two things I can see would give you issues is trying to select a range.

 

[Fluff]

On top of what Joe has asked, where is the code located? Is it in a standard module, sheet mode, ThisWorkbook module, or somewhere else?

 

[WallisAggie646777]

Welcome to the Board!

On top of what Joe has asked, where is the code located? Is it in a standard module, sheet mode, ThisWorkbook module, or somewhere else?

The code is in the "Weekly" worksheet mode

Do you have any hidden rows or columns, or any protection going on?
Other than merged cells, those are the only other two things I can see would give you issues is trying to select a range.

 

[MARK858]

The code is in the "Weekly" worksheet mode

Then you need to change

Range("O7:T32").Select

to

Sheets("Groups").Range("O7:T32").Select

or avoid the selecting altogether

Sheets("Groups").Range("O7:T32").Copy
Sheets("Temp").Range("A1").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False