Autofill?

wofinufu · Feb 11th 2021

I am new to the forum so thanks for the warm welcome everyone!

I am trying to take Column A multiply it by some pre-calculated factor D1 with the output in Column B.

Normally I would just use autofill, but this is sheet could have any number of rows. I found the following snippet, but it doesn't quite work for me.

Code

Range("A1").Select
numRows = Range(Selection, Selection.End(xlDown)).Rows.Count
Selection.AutoFill Destination:=Range(Cells(1, 2), Cells(numRows, 2)), Type:=xlFillDefault

Thank you in advance for any help!

**Carim** · Feb 11th 2021

Hello and Welcome to the Forum

You could test the following

Code

Hope this will help

**royUK** · Feb 11th 2021

I can't see any reason to use VBA for this. A formula would be more efficient.

Share