What I'm trying to do is use the refedit function in a user form to allow the user to select a group of cells. What I want the form then to be able to do is move those cells (not the refedit value) onto a different spreadsheet. I seem to be getting tied up in being able to parse out the Sheet!refedit value and am unable to copy those cells to a different sheet.
So if the user selected Sheet99!B2:E30 so refedit = Sheet99!B2:E30
I would like Sheet99!B2:E30 copy/moved to a different sheet
Hope this makes sense?
So if the user selected Sheet99!B2:E30 so refedit = Sheet99!B2:E30
I would like Sheet99!B2:E30 copy/moved to a different sheet
Hope this makes sense?