Hi, everyone. I too wanted to use Msgbox to input to last row. I have an Add new account button executing the macro below, with intentions putting input in A14 and below.
Columns:
Account Make pmt Bill type Pmt Interval
Type & Pmt Interval are date validation lists containing options from rows 4 to 13. So rows 4 to 13 are hidden with "starting" row at 14. If I use the macro as is, it sends input to A4 only, even if I populate a4..a13 with filler. If those rows are unhidden and populated, the input goes to A14.
How can I use this macro or modify it to populate cells after the hidden rows above it? The code follows:
Thanks in advance
Bookmarks