I have an "Application" I've been working with in Excel using a lot of
VB Scripting behind the scenes. I have pages with "Button" Objects that
reference adjscent cells. I am having trouble associating the specific
buttons to the rows and also having them paste to one specific page.
There are 50+ Pages of these objects (20-30 buttons per page) and 1
final page recieving the pasted text from these 50+ pages. I also need
to "find next blank row" in a certain range to paste this text.

Since the options of pasting the text could start on any one of the 50
pages, I need to set a variable to look for the next abailable blank
row on the last page so that the data will past in the order they chose
the "buttons" that they clicked. My code for finding the next available
row is not working.

Side question, How does "merged" cells affect the outcome of using a
range correctly in a formula for pasting?

Any suggestions?