It would help if you posted the macro, but often the solution is to change code like

Range("A2:C10").Copy .....

to

Selection.Copy

HTH,
Bernie
MS Excel MVP


"Satish" wrote in message
...
I am looking for a macro which copies the data from the selected
range(Dynamic range) and pastes it into a different sheet. I tried recording
a macro and run it,but the range is fixed. The range should be the selected
text and should not be fixed range.
Thanks in advance.