You have set the range without a reference to any column.

Try changing it up to look like this:

Public rng6 As Range
Set rng6 = Range("A463:A478")
It will not matter that you indicate a column since you are selecting the entire row to hide