Thanks for the reply, Stephen.
That's close, but there are a couple of issues.
My biggest problem is I noticed that Excel doesn't give you the accumulated sum at the bottom of the window when you are selecting while in a macro. Unless there is a way to use VBA to show a total cube selected while selecting the cells, then we may need to go back to selecting the cells before running the macro. The primary goal is to allow the user to select how many cubic feet they are putting on an order, so I need to figure out how to display the cube data while selecting.
It would be easy to adapt your code to copy the cells that have already been selected. This seems to work:
I can incorporate that into my macro, unless you know of a better way to display the cube while being selected.
Thanks for all your help.
Bookmarks