Can somebody help me why i kept getting the error msg:

<Method 'Range' of object '_Worksheet' failed>

here is my simple code:

Dim dtRpt As String
Private Sub cmdSPMIS_Click()
    dtRpt = Sheet1.Range(A1).Value
End Sub

that code alone produces the error.
'i will be using the variable dtRpt in restricting when I filter my recordset.

bembem

guys its ok. I just have to enclose the A1 with ""

making it :

dtRpt = Sheet1.Range("A1").Value

*smiles shyly*
bembem