Hi Guys,

I am trying to sort a range of cells using VBA inside an excel
application using this code:

Worksheets(ProdGeog).Range("B" & gchk1 & ":M" & gchk2).Sort _
Key1:=Worksheets(ProdGeog).Range("J" & gchk1),
Order1:=xlDescending, _
Key2:=Worksheets(ProdGeog).Range("I" & gchk1),
Order2:=xlAscending, _
Key3:=Worksheets(ProdGeog).Range("B" & gchk1),
Order3:=xlAscending, _
Header:=xlNo

This sort is used to update certain graphs in the application.

If I run the whole application, it doesn't sort properly, however if I
debug the subroutine using F8 ( step-by-step iteration), it sorts
correctly.

Any pointers as to why it doesn't do it in the first place.

Thanks,
Ravi