Hi all
Very new to VBA code and trying to do something relatively simple. I have a booking sheet in an excel Table and in column M once booking is made, the person selects from a drop down box their name and column N inserts the date and time which remains unchanged. I have the same formula for Column V and W.
Below is the VBA code I use
This works for column 22/23 (V/W/) except if I drag to fill multiple cells.
It works for column 13/14 (M/N) in existing table rows. However, it also doesn't work if I drag and drop column M to fill multiple cells. Worst of all I get Runtime Error 13, type mismatch every time I insert a new row into the table and it identifies the bold row as the problem.
Please help!!!
Bookmarks