Selecting or determining the active row.

I am looking for a way to select the active row. Either row 18 or row 21 depending on which value I want to change. The code I have for row 18 is as follows.

Please Login or Register  to view this content.

It just subtracts the amount entered from the total amount of boxes in inventory and sends a copy to the history sheet when the Active X button is pressed. I have added row 21 and will add more rows to sheet 1 later, but I need my code to realize which row I am selected in, so it only makes changes in one row at a time. Nothing I have tried has worked.

Please Login or Register  to view this content.

will return the active row.

What if I only want to select the three cells in the row? Cells B18:D18

Please Login or Register  to view this content.

Can someone tell me why the highlighted part of the code keeps giving me an error message. It says method, range of object failed. When I am in the debugger mode, it is returning the proper value, so it does know which cell value I am asking for. Any help appreciated.

You are trying to set the value of a range to R1, which is a range object. Whereas the value of a range is not a range object. So you need either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

not, you can also use

Please Login or Register  to view this content.

in place of the range(cells( construct.

This is the final coding I came up with. Now I will be able to add other items to track on sheet1 as long as they are in the B, C, and D columns. Only the row selected will be active and I did not have to name a specific cell for the subtraction or the copying to the History Sheet.

Thanks for the help!!

Please Login or Register  to view this content.

If you look in module 3, you will see this code and a whole other way to copy and paste to the another sheet.