Walkerwood9
New Member
- Joined
- Jun 23, 2020
- Messages
- 17
- Office Version
- 365
- 2016
- Platform
- Windows
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..?!?
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..?!?