Problem copying values to a worksheet

[Grilleman]

After choosing a value from a ComboBox the following code executes. However, it's placing the selected value in column C in the "first blank row". I need the value to be placed in the "first row" even if this row contains values in other cells. By the way, the first row containing data is row 6. My column headers are displayed across row 5.

Please Login or Register  to view this content.

Thanks!

[Mad-Mizer]

Try

Please Login or Register  to view this content.

All I did was remove the Offset.