Editing a vba script to work with different columns

**Mr_Bill** · 09-01-2014, 11:01 PM

I tried getting help on this script on another forum and not able to get any help on it.

I currently have a macro that works for columns 1:5

Please Login or Register  to view this content.

I would like to know how would I make the script work with columns 7:11 with 10 being the sortKeyCol. Here is what I tried

Please Login or Register  to view this content.

Not sure what I need to change in the code itself to prevent getting a run-time 9 error and make it work. Could someone lend a hand with this please.

**Cerbera** · 09-01-2014, 11:13 PM

Could you post some sample data (doesn't have to be real info) in a spreadsheet, preferably with the macro built in?

This will make it easier to work through.

Thanks

**Mr_Bill** · 09-01-2014, 11:32 PM

Here is stripped down version with the working and broken scripts
https://www.dropbox.com/s/fek37xem5n...mple.xlsm?dl=0

**Mr_Bill** · 09-02-2014, 01:23 PM

Could someone who has a second to look at this please let me know if this can be done simply by editing or does another script need to be wrote.

**millz** · 09-02-2014, 09:27 PM

Hi Bill, here is the amended version. Not sure if you need it, but I've added a sort key row. Note that the sort key row/col should be the row/col of the sort area, not row/col of the worksheet, and there's no need for "end col".

Please Login or Register  to view this content.

**Mr_Bill** · 09-02-2014, 09:42 PM

millz you are my HERO!!!! I love it Thank You. I can not wait to add it the sheet and try this bad boy out. When I am done adding this and doing a few more things care to see the final product?

From a educational stand point can not wait to compare this to the old one side by to see the changes