Autofill with variable instead of reference cell

Hi guys,

new to the forum, so apologies if this is already covered and I didnt find it.

I want to autofill down a column, based on the presence of data in another column.

For example, this is the data column that exists:

a
a
b
b

And I want to fill down in a second column an if statement:

=if(a1="a","1","2")

However, for various reasons related to the usage of this workbook, I cannot rely on the formula remaining present in the source cell of an autofill script.

Currently, I have this:

Public Sub autofill()
Worksheets("Sheet4").Range("B1").autofill Destination:=Range("B1:B" & Cells(Rows.Count, "A").End(xlUp).Row)
End Sub

What I need is to replace "Worksheets("Sheet4").Range("B1")" with the formula itself.

Anyone have a solution here?

thanks!

Wiggin

Thanks!

Just started working with OO programming, so I will probably ask some worthless questions for a couple of months, but ill get there. Thanks for the help.

best,

Wiggin

This solution is great, however i want to add one more layer to it, and I cant quite crack it.

In the same scenario, I want to make sure this macro does not "re-do" any cells that have already been completed by the macro in a previous session (in case formula has to change). For example, if I had this:

a 1
a 1
b 2
b 2
a
a
b
b

what would I need to add to the macro to make sure it didnt redo the formula for the first 4 rows, and applied it only to the last 4 rows?

Many thanks!!

John Mc.