You are only defining a single cell to sort (a bit pointless no?).

You might mean all rows between the first and last
.Rows(intFirstRow & ":" & intSecondRow).Sort

or perhaps you mean only some columns, say H:M, in which case use
.Range(.Cells(intFirstRow,"H"),.Cells(intSecondRow,"M")).Sort

And then you haven't specified the key to sort on, which should be the first
data cell in a specific column.

BTW, Dim intFirstRow, intSecondRow as Integer doesn't declare both variables
as Integer, the first is a variant. You have to be specific

Dim intFirstRow as Integer, intSecondRow as Integer

--

HTH



RP
(remove nothere from the email address if mailing direct)


"Kevin" <Kevin@discussions.microsoft.com> wrote in message
news:4F83D338-EF8E-452D-B2D2-A5BE9EC58E9A@microsoft.com...
> OK. I've got a feeling that I'm going to feel like an idiot when someone
> tells me what I'm doing wrong, but I am having trouble sorting rows in
VBA.
> Consider the following code snippet:
>
> Dim intFirstRow, intSecondRow as Integer
> intFirstRow = 9
> intSecondRow = 15
> With ActiveSheet
> .Rows(intFirstRow, intSecondRow).Sort
> End With
>
> I keep getting run-time error 1004 which says "Application-defined or
> object-defined error", which seems to mean: Something is wrong. VBA's not
> sure what it is, but something is definitely wrong.
>
> Alternatively, I tried the line:
> .Rows(.Rows(intFirstRow),.Rows(intSecondRow)).Sort
>
> I got the same error.
>
> Can anyone point me in the right direction?
>
> Thanks in advance!!!
>
> --
> Kevin