How set range cells in a different sheet

See more:

MS-Excel

VBA

Hi there,

I want to import data from sql server into Excel using vba. The problem is I don't want the data to fire in sheet1 but rather in sheet2 but I 'm having problems setting the range for sheet2. In sheet1 is a button.

' Remove any values in the cells where to fire the sp results.

Dim rngRange As Range
Set rngRange = ThisWorkbook.Worksheets("Sheet2").Range(Cells(2, 1), Cells(Rows.Count,1)).EntireRow  
rngRange.ClearContents

The error is on the line 'Set rngRange= ...'