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!

feel free to watch this live sex cam sites:

🍛 Indian Live Sex Cam – indian cam girls, desi live cam, tamil webcam 🍛

🎬 Lesbian Cam – lesbian cam girls, lesbian live webca

🐱 Lesbian Live Cam – lesbian cam chat, live lesbian sex🐱

**Carim** · Feb 11th 2021

Hello and Welcome to the Forum

You could test the following

Code

Sub MultTest()
Dim last As Long
   last = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
    Range("B1:B" & last).FormulaR1C1 = "=RC[-1]*R1C4"
End Sub

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.

Autofill?

Participate now!

Share