VBA won't sort sheet

**bigmacro** · 07-25-2018, 01:18 PM

I need help with this VBA code, it's not sorting the sheet.

At first my Ranges were cell specific so I tried adjusting to get the LastRow info so that it would sort all the data instead of just the max row when I had recorded the macro, BUT it was at least sorting.

When I tired adding the Lastrow pieces, it doesn't sort at all now...

HELP

thanks everybody!!

Please Login or Register  to view this content.

**Arkadi** · 07-25-2018, 01:21 PM

Ranges like:

Please Login or Register  to view this content.

Don't really exist...or they do... but imagine lastrow is 200... that just means you are sorting Range("D2200"). Perhaps you mean:

Please Login or Register  to view this content.

**bigmacro** · 07-25-2018, 01:27 PM

*facepalm I changed it all to

Please Login or Register  to view this content.

, but it's still not sorting.

**Norie** · 07-25-2018, 01:28 PM

Try this.

Please Login or Register  to view this content.

**bigmacro** · 07-25-2018, 01:29 PM

Got it! had to change the very last Range to "A1:K1" & Lastrow.

thank you

VBA won't sort sheet

LinkBack

Thread Tools

Rate This Thread

Display

VBA won't sort sheet

Re: VBA won't sort sheet

Re: VBA won't sort sheet

Re: VBA won't sort sheet

Re: VBA won't sort sheet

Thread Information

Users Browsing this Thread

Similar Threads

VBA/Macro to Automatically Update, Copy, & Sort information from Sheet 1 to Sheet 2

[SOLVED] vba code to sort data in two sheets and copy and paste sort data in output sheet

[SOLVED] Excel 2016 Sort routine issue - recording macro has sheet name in sort routine

match/sort - lookup data from one sheet and link to other sheet -

Sort sheet, highlight, undo sort

[SOLVED] Sort Functions are Disabled When Sheet is Protected, and more Issue When Sheet is Shared

Macro to Look for Sheet, create if none, sort items from master & copy to new sheet.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions