macro to copy cells based on user input

how have a macro to copy a range of cells (name range) that the user specifies to a new worksheet?

Request is a tad vague - you don't specify how you wish to capture named range and "new worksheet" could mean create an entirely new sheet or use another sheet already created... you also need to specify what exactly you intend to copy (everything, values only (ie no formulae) etc

At a rough guess

Please Login or Register  to view this content.

there are plenty of other approaches - the above is just one.