VBA code to generate VBA code

[Elemental]

i was thinking of making a VBA button that selects data on a sheet and copies just the values to another sheet( range from A1 to E100 ), but on the newly created sheet, i wanted to move the sheet to the end of the list, generate a new button on that sheet, and setup the code/properties for it to clear just the data on that temporary sheet

of course i could have a print button for that sheet too, but that's not the hard part



/////////////////////////////////
Private Sub MakeCopy_Click()

' Mysterious Code

End Sub
/////////////////////////////////

thanks ppl

 

[Gates Is Antichrist]

> do you guys have day jobs or what's the deal?

Speaking solely to Gregor: the answer to that lies in the last words of the last [listed ] song of Abbey Road (which was the "last" Beatle album). The answer is in The End.

More than once in a while, it also generates a "thank you," after I see an enormous amount of uncompensated time and thought poured into a reply. In particular, Ivan will always be an "owee" rather an "ower" in the scorecard of life - which ain't a bad place to be