Hi,
I'm trying to add data to a revenue sheet using a userform. Currently, I have this Sub to accomplish this:

Private Sub OkButton_Click()

Dim emptyRow As Long

'Make Revenue Active
Revenue.Activate

'Determine emptyRow
emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1

'Transfer Info
Cells(emptyRow, 1).Value = DateBox.Value
Cells(emptyRow, 2).Value = ShowLocBox.Value
Cells(emptyRow, 3).Value = ProvBox.Value
Cells(emptyRow, 7).Value = GuaranteeBox.Value
Cells(emptyRow, 8).Value = GSTBox.Value
Cells(emptyRow, 9).Value = OverageBox.Value
etc... for various amounts

End Sub

I'd like the data to be entered into a table, in which some columns contain formulas or values already. My problem with this code is that the data is inputted into the sheet below the table, not in it (because the rows in the table have some values in already). Is there a way to have it so columns 'A','B', and 'C' are checked in a row to be empty? And then if they are, the data will be inputted.

Thank you!!