Hi All

I am updating a wsheet via a form using vb to locate next empy row etc.

The issue I have is with the formula's no matter how I try I cannot get the formula to increment with each row. I know I can drag and auto fill on the sheet but I want to use vb if poss. eg

Previous entry to sheet:-

A1=1

B1=2

c1=A1+B1(formula)

New entry via form selecting next empty.

A2=(updated from form.)

B2=(Updated from form.)

C2=(Update code VB)

This is all okay and functional the problem starts from here

I so far have been unable to increment the formula in c1 from A1+B1 to A2+B2 using vb, is this possible or am I just chasing my tail.

Thanks for any input

Chaz

I am updating a wsheet via a form using vb to locate next empy row etc.

The issue I have is with the formula's no matter how I try I cannot get the formula to increment with each row. I know I can drag and auto fill on the sheet but I want to use vb if poss. eg

Previous entry to sheet:-

A1=1

B1=2

c1=A1+B1(formula)

New entry via form selecting next empty.

A2=(updated from form.)

B2=(Updated from form.)

C2=(Update code VB)

This is all okay and functional the problem starts from here

I so far have been unable to increment the formula in c1 from A1+B1 to A2+B2 using vb, is this possible or am I just chasing my tail.

Thanks for any input

Chaz

## Comment