View Full Version : Solved: Sorting a column

11-18-2008, 08:44 AM
I tried to sort a column on a comparable basis to what I found on here. However I get a runtime error. Does anyone have an idea what could be wrong?

shPrintout.Range("G:G").Sort Key1:=shPrintout.Range("G4")

EDIT: I found that a Merged cell was the problem.

11-18-2008, 09:53 AM
I avoid merged cells at all costs.......even if I risk making someone mad.......they are the cause of many problems when vba is implemented.