Auto fill Cells Down if other cells have information

[Learning ExL]

Hi All

i have formulas in Columns H through I and N through P but these are in a table.

i use a userform which adds information in columns B through G and M and Q, column R is and index col.

my question is how can i get the cells to auto fill down when the other cells have data put in to them from the userform please

here is a picture of my userform

https://www.dropbox.com/s/hjnl3ouewg...ofill.jpg?dl=0

and here is the code to my add button on the user form

Please Login or Register  to view this content.

thank you in advance all

and here is a picture of my sheet

https://www.dropbox.com/s/42frx47g3j...36.44.png?dl=0

[Learning ExL]

***SOLVED**** thank you

[millz]

You may have a mistake here since offsetting 6 columns from column B (range object Drng) would end you up in column H already.

Anyway, try adding this and adjust accordingly. Untested though.

Please Login or Register  to view this content.