View Single Post
 
Old 09-19-2013, 05:16 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Mikec, can you attach a copy of the worksheet with both versions of the program (in separate modules if necessary)? I don't use ListObjects, but I suspect what's going on here, based on the error you report, is that Range.ListObject.Sort.SortFields.Add Key:= requires a Range object, and Range.ListObject.ListColumns(1) is some other type. But I want to step into the program to inspect the objects to be sure.

Or you can, of course. But I'm interested in learning it myself, anyway.
Reply With Quote