Clear content below row A VBA

[drop05]

Hello, I am trying to find a way to use VBA to clear all cells below row 1 on an excel worksheet.
Row A has headers I want to keep but would like vba code that I can put into a button to clear all cells under row 1, so clear rows 2,3,4, etc.. Also the sheet is called "User Info". So would like to see i could incorporate that

Tried using this but it is clearing the whole worksheet
first book is the workbook i dim

 firstbook.Worksheets("User Info").Cells.clear

 

[Peter_SSs]

Assuming that you have set 'main' appropriately, test this.

main.Worksheets("User Info").UsedRange.Offset(1).Clear

 

[drop05]

I am getting a run time error 1004
clear method of range class failed

at the main.worksheets part

Sub test()

Dim main As Workbook
Set main = Application.ThisWorkbook

main.Worksheets("User Info").UsedRange.Offset(1).clear


End Sub

 

[drop05]

This is similar to how the page is laid out with the row of header is the one i want to keep then everything end to be cleared and the header is on row 1 goes from A to row IN, if that helps too

Header	Header	Header	Header	Header	Header
value 1	value 2	value 3	value 4	value 5	value 6
name 1	name 2	name 3	name 4	name 5	name 6

 

[Peter_SSs]

The code worked fine for me with that set-up.
There must be something different about your worksheet.

To test, start a completely fresh workbook, name a sheet 'User Info', put some dummy data into each of the 4 cells A1:B2
Put the code into that workbook and run it. See what happens.