Adding data to the end of a dynamic table

[Coppa]

Hi.

I have created a form and I capture 2 outputs, (cboregion, and txtcountry) which i would like to add to the end of a dynamic table (the table currently sits in E10:F28, but i have named it Marketdata).

I'm struggling to get the function which adds the new data to the end of the table to work.

With Range("Marketdata").End(xlDown)

.Value = .Offset(-1).Value + 1
.Offset(, 1).Value = cboregion
.Offset(, 2).Value = txtCountry

Thanks

 

[VoG]

Try

With Range("Marketdata").Offset(Range("Marketdata").Rows.Count).End(xlUp).Offset(1)

 

[Coppa]

Thanks! That works