Issues when filling down a column in a macro

[Walkerwood9]

I am having an issue with some code that has been working fine until now. I am having an issue where when my macro runs and starts to copy down a formula into the rest of the column it copies down the headers to the entire column instead.
Here is the code:

Range (“G427”).Select
Selection.End(xlDown).Select
ActiveCell.Offset(0,2).Select
Range(Selection, Selection.End(xlUp)).Select
Selection.FillDown

End of code:
The header is in row 2 and the column I am trying to fill out is column “I” specifically cells 427 and down. I am not sure why it keeps going up to the headers and copying those down all the way down the column..?!?

 

[jmacleary]

Hi there.

The problem will be the xlUp selection you are doing. If column I is empty apart from the header, it will end up selecting the header row.
Try this instead:

Sub ender()
Range("G427").Select
Selection.End(xlDown).Select
ActiveCell.Offset(0, 2).Select
Range("I427", Selection).Select
Selection.FillDown
End Sub