Highlighting Filtred Data Only - Exclude Header

[SkysLastChance]

$oExcel.ActiveSheet.AutoFilter.Range.Rows.Columns(30).SpecialCells($xlCellTypeVisible).Interior.ColorIndex = 37
$oExcel.ActiveSheet.AutoFilter.Range.Rows.Columns(30).SpecialCells($xlCellTypeVisible).Value = 0

I have a script that is filtering a range of data using the code above. 

I am using this to highlight and change the value to 0 in column 30 (AD)  (Filtred Data Only)

However, I don't want to include the header. What would be the a good/clean way to exclude the header row?

Otherwise, I am just planning to re-fill in the header row in with _Excel_Rangewrite. 

 

Edited July 25, 2022 by SkysLastChance
Spelling

[SkysLastChance]

Local $xlup = -4162
$LastRow = $oWorkbook.ActiveSheet.Range("A1000000").End($xlup).Row

$oExcel.ActiveSheet.AutoFilter.Range.Rows("2:" & $LastRow).Columns(30).SpecialCells($xlCellTypeVisible).Interior.ColorIndex = 37
$oExcel.ActiveSheet.AutoFilter.Range.Rows("2:" & $LastRow).Columns(30).SpecialCells($xlCellTypeVisible).Value = 0

This seemed to do the trick. 

Edited July 25, 2022 by SkysLastChance