I want to sort out one column (it is a target date and I want to sort it out by earliest date).
The thing is that the first row is a text (name of the column), so when I sort it out by column F (Target Date), text row goes to the very end of the excel document.
I would like for this column names to stay and be on top of every column.
Column I want to sort out
Here is the code:
$objRange = $worksheet.UsedRange
$objRange2 = $Excel.Range("F2")
Since your range has headers, you have to add an argument to the Sort method to indicate it should not sort the headers.
Your range command would then look like this:
The Sort method doesn't like $null for the xlSortOrder parameters so I just specified 1 which means ascending. If you need descending, use 2. The last 1 is the parameter we really care about. Specifying 1 means yes, the range has headers that should not be included in the sort operation.