Include additional column to sort in this code

[RAJESH SHAH]

Hello Experts
I have this code shared by bebo012999 which sorts one column of data only. I want to include column B and sort the data. Also I want to align the cells of column A to the left and remove the borders. I tried to include column B by editing the code but I am getting an error each time. Hope someone can help me to edit and correct this code with the additional requirement in the code.
This is the edited code by it is not sorting the first row below the heading (2nd row in the sheet).

Please Login or Register  to view this content.

TYIA

[Marc L]

Hello,

sort logic error : include at least the headers row in the range to sort or parameter the sort with no header …

If you do not understand only : do it manually and once you succeed go back to the previous state,
activate the Macro Recorder and redo the same then you could compare with the generated code …

[RAJESH SHAH]

The above issue is solved.