Hello - I am new to VBA code, especially in Excel. I have a small membership project that currently records member data. Now I want to expand on the project and add additional features. I am hoping to develope a relation between 2 or more tables to facilitate some reporting. But, first things first.

I am currently using the following code to add records to my current sheet range. Now I want to convert the range into a table however the code does not work as is. What I need help with is how to edit the line
If WorksheetFunction.CountIf(Sheet2.Range("H:H"), Me.Reg6.Value) > 0 Then
to point to a table instead of the range. I've tried a few things without success.

Please Login or Register  to view this content.