how do i select the 5th sheet VBQ

[Dark0Prince]

Sheets("Sheets(5)").Select

is what I've tried so far and it's not working .

 

[PatOBrien198]

try:

Sheets(5).Select

or

Sheets("Sheet5").Select

 

[Dark0Prince]

Thanks, But all of a sudden my headers were cleared on sheet 5. Here is my code.

Sub Clear_Previous_Data()
'
' Clear_Previous_Data Macro
'

'
    Sheets("3.7.2_ABQCSR_REPORT").Select
    Range("A2").Select
    Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
    Selection.ClearContents
    
    Sheets("8.6.1_CALLS_CONTACTS").Select
    Range("A2").Select
    Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
    Selection.ClearContents
    
    Sheets("3.1.1_ABQPD").Select
    Range("A2").Select
    Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
    Selection.ClearContents


    Sheets(5).Select
    Range("A2").Select
    Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
    Selection.ClearContents
    
End Sub

 

[Fluff]

Did you have any data on that sheet other than the headers?
Or do you have any merged cells on rows 1 & 2?

 

[Dark0Prince]

It just started working. not sure why but I didn't even change the code or formating of the sheet. TY though.