Adjust a code from cell range trigger to button trigger

Hi all,

I have the code below that is two separate activities and I want to change the second activity from a cell trigger (Set KeyCells = Range("K42:AD42")) to a button trigger. I need to first to remain unchanged.

I'd be ok if this was just one macro that I could assign to a button but because its two and I need to write the second's to clicking a button I'm over my head.

Its occured to me while writing this that because it'll be a range of buttons I'll probably need to make each one an individual code? Is this the case? If so I may have to just keep this as it is

Any advice would be appreciated!

Please Login or Register  to view this content.

Hi ld2x07,

The following should work with a Command Button and only this one routine.
The User has to select a cell in the range before clicking on the command button.
This routine should go in an ordinary code module such as 'Module1'.

Changes in red.

Please Login or Register  to view this content.

Lewis

Hi Lewis,

Many thanks for your help. Its an interesting approach and pretty neat

Thanks
Leo