Blank row & new sheet

[Cheshire]

I have a sheet with three shapes which will be used as buttons.
' shape1 ' when clicked needs to return the the first empty row on sheet ' inventoryA ' to cell A1
' shape2 ' needs to return the first empty row on sheet ' inventoryB ' to cell B1.
And so on.

The tricky part for me is I need a macro that could be applied to shape1 and shape2 yet still return the proper results. This is inticipation of having to add more buttons/shapes to my sheet.

I figure I could possibly use the shapes' name to input variables into the macro.
Something like shape1 is renamed to "shape1A", then reference the 'A', concatenate it with the word 'inventory', search sheet name 'inventoryA', then return the row number for the first empty row.

I'm sorry if this is asking too much, but I would be most appreciative of any and all help.

Thank you ahead of time =]


-Aaron

[shg]

' shape1 ' when clicked needs to return the the first empty row on sheet ' inventoryA ' to cell A1

What does that mean? insert a blank row?

[Cheshire]

Sorry,
To (attempt to) clarify:

When the shape called 'shape1' is clicked, I need a macro to execute which first identifies which sheet is called 'inventoryA', then figured out the next empty row on that particular sheet, and to set the value of cell A1 to whatever the row number of the empty row on sheet 'inventoryA' was found to be.

[shg]

Please Login or Register  to view this content.

Why not just use a formula?