VBA AutoFill formula to adjacent cells

[jerryneubauer]

I have a report that returns a variable amount of rows depending on the number of transactions returned.

I have my cursor located in the last occupied cell in Col. "F", which contains an AutoSum formula. This formula needs to be copied to the next 5 cells to the right (along with the formatting of that cell)

In this example assume:
1. The cursor is located at "F492".
2. Data begins on row 5.
3. The formula will copy to the 5 adjacent cells to the right (G-K).

Thanks.

 

[JoeMo]

Maybe:

Activecell.resize(1,6).FillRight

 

[jerryneubauer]

Thanks.

 

[JoeMo]

Thanks.

You are welcome - thanks for the reply.

 

[jerryneubauer]

I'm getting too old for this ****!