I am trying to enter data into a table which is split into two sides using data entry forms.
This works just fine manually, but when I try to automate it and use macros operated by a buttons (input part a) and (input part b) I only get the data entry form form for part a despite first selecting the cells for part b. I have tried a couple of ways of doing it, see code below
For part a
For part b
I have left column c blank to split the table
I have also tried using Column.Select which also didn't work. When I press button for part b it brings up the data entry form for part a.
Any ideas?
Bookmarks