Sort A-Z on a worksheet question

[ipbr21054]

Morning,
Just asking before I start.

I wish to have a user form where I send the values to the worksheet.

Lets assume the values will be inserted at F5:F12 then sorted A-Z in column F

My question is can it be sorted so the sort doesn’t touch the values that are in columns A5:E5

Or please advise otherwise.

 

[rollis13]

Glad having been of some help .

 

[ipbr21054]

Tomorrow I need to now add code so when the values are sent to the worksheet they will be formatted for,
Bold
Calibri
Borders all around
Center alignment

Night.

 

[rollis13]

But that's another argument, this was for 'sorting A-Z' even if it ended up 'filling the right cells'.
I would say you should and should've started a new thread with a different title.

 

[ipbr21054]

Yes I will Tomorrow