Microsoft Office Forums - View Single Post - [Solved] runtime error 1004

Thread: [Solved] runtime error 1004

View Single Post

Old

06-03-2012, 07:05 AM

gbaker

gbaker is offline

gbaker uses Windows 7 32bit

Windows 7 32bit gbaker uses Office 2010 32bit

gbaker uses Office 2010 32bit

Office 2010 32bit

Competent Performer

The original poster

Join Date: May 2012

Posts: 111

gbaker is on a distinguished road

Default

Runtime 1004

Hi Colin,
I tried the new code a couple times and still get and error.
Stops at:

Code:

.SortFields.Add _
                     Key:=fRange, _
                     SortOn:=xlSortOnValues, _
                     Order:=xlAscending, _
                     DataOption:=xlSortNormal

Thanks

Reply With Quote