ExcelBanter - Autofill column header to the last column

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Autofill column header to the last column (https://www.excelbanter.com/excel-worksheet-functions/120917-autofill-column-header-last-column.html)

Megadrone

Autofill column header to the last column

I need a variable to populate "Channel" as the column header to the last
column to the right. Assuming that there are 400 or so rows and only a few
will be populated to the right.

Range("V1").Select
ActiveCell.FormulaR1C1 = "Channel"
Selection.AutoFill Destination:=Range("V1:J21"), Type:=xlFillDefault
Range("V1:AJ1").Select

All times are GMT +1. The time now is 07:29 PM.