Query

[jyoti.vichare]

Hi
I have one query, after i copy paste the excel sheet the sheet which i have copied it contains formula after i paste it somewhere else it shoudn't show the formulas in pasted sheet only viewer can see the values how to do this? please do the needful
Regards
Jyoti

 

[VoG]

Copy the range, select the destination range, Edit > Paste Special, tick Values and click OK.

 

[jyoti.vichare]

Thanks but i want to copy the entire sheet like from right click copy and paste it to another location
Thanks in advance

 

[VoG]

Select all of your copied sheet, copy it then Edit > Paste Special > Values.

 

[jyoti.vichare]

I want to copy the whole sheet as it is and when i paste it , it shouldn't show the formula like what i was thinking if i do it using macro and put RUN button after clicking on run button it should run the formulas in pasted sheet . using macro will it be possible?

Thanks

 

[VoG]

Try this with your copied sheet selected.

Sub NoFormulas()
With ActiveSheet.UsedRange
    .Value = .Value
End With
End Sub