This is a continuation of this post: http://www.mrexcel.com/board2/viewtopic.php?t=184911&highlight=
The previous post had solved my problem, until my users decided things should change. Here is the new situation:
I have a worksheet with 20+ sections where specific items will be pasted. The buttons that originally pasted those items were located next to those sections. However, the users have demanded a wizard to step through the process. The button that pasted the items has now been changed to load a wizard (userform with multipage control). In that wizard is the button that pastes the item, but that button pastes only to a specific range.
Can I make the range of pasting change according to which button loaded the wizard?
The previous post had solved my problem, until my users decided things should change. Here is the new situation:
I have a worksheet with 20+ sections where specific items will be pasted. The buttons that originally pasted those items were located next to those sections. However, the users have demanded a wizard to step through the process. The button that pasted the items has now been changed to load a wizard (userform with multipage control). In that wizard is the button that pastes the item, but that button pastes only to a specific range.
Can I make the range of pasting change according to which button loaded the wizard?