Copy/Paste used range

[gtd526]

Hello,
Looking to copy/pasteSV where formulas have a result, not a blank formula. I want to leave the empty formulas active.
The range is AE5:AL12. Only AE5:AE12 should be copy/pasted.
thank you.

NBA.xlsm
	AE	AF	AG	AH	AI	AJ	AK	AL
5	ATL
6	CHI
7	MIA
8	PHI
9	GSW
10	SAC
11	LAL
12	NOP
Playoff Favs

Cell Formulas
Range	Formula
AE5:AE8	AE5	=$E28
AF5	AF5	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=1)/(Team=$AE$5),WL),"")
AG5	AG5	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=2)/(Team=$AE$5),WL),"")
AH5	AH5	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=3)/(Team=$AE$5),WL),"")
AI5	AI5	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=4)/(Team=$AE$5),WL),"")
AJ5	AJ5	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=5)/(Team=$AE$5),WL),"")
AK5	AK5	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=6)/(Team=$AE$5),WL),"")
AL5	AL5	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=7)/(Team=$AE$5),WL),"")
AF6	AF6	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=1)/(Team=$AE$6),WL),"")
AG6	AG6	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=2)/(Team=$AE$6),WL),"")
AH6	AH6	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=3)/(Team=$AE$6),WL),"")
AI6	AI6	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=4)/(Team=$AE$6),WL),"")
AJ6	AJ6	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=5)/(Team=$AE$6),WL),"")
AK6	AK6	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=6)/(Team=$AE$6),WL),"")
AL6	AL6	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=7)/(Team=$AE$6),WL),"")
AF7	AF7	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=1)/(Team=$AE$7),WL),"")
AG7	AG7	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=2)/(Team=$AE$7),WL),"")
AH7	AH7	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=3)/(Team=$AE$7),WL),"")
AI7	AI7	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=4)/(Team=$AE$7),WL),"")
AJ7	AJ7	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=5)/(Team=$AE$7),WL),"")
AK7	AK7	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=6)/(Team=$AE$7),WL),"")
AL7	AL7	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=7)/(Team=$AE$7),WL),"")
AF8	AF8	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=1)/(Team=$AE$8),WL),"")
AG8	AG8	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=2)/(Team=$AE$8),WL),"")
AH8	AH8	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=3)/(Team=$AE$8),WL),"")
AI8	AI8	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=4)/(Team=$AE$8),WL),"")
AJ8	AJ8	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=5)/(Team=$AE$8),WL),"")
AK8	AK8	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=6)/(Team=$AE$8),WL),"")
AL8	AL8	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="East")/(Game=7)/(Team=$AE$8),WL),"")
AE9:AE12	AE9	=$E36
AF9	AF9	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=1)/(Team=$AE$9),WL),"")
AG9	AG9	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=2)/(Team=$AE$9),WL),"")
AH9	AH9	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=3)/(Team=$AE$9),WL),"")
AI9	AI9	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=4)/(Team=$AE$9),WL),"")
AJ9	AJ9	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=5)/(Team=$AE$9),WL),"")
AK9	AK9	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=6)/(Team=$AE$9),WL),"")
AL9	AL9	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=7)/(Team=$AE$9),WL),"")
AF10	AF10	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=1)/(Team=$AE$10),WL),"")
AG10	AG10	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=2)/(Team=$AE$10),WL),"")
AH10	AH10	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=3)/(Team=$AE$10),WL),"")
AI10	AI10	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=4)/(Team=$AE$10),WL),"")
AJ10	AJ10	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=5)/(Team=$AE$10),WL),"")
AK10	AK10	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=6)/(Team=$AE$10),WL),"")
AL10	AL10	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=7)/(Team=$AE$10),WL),"")
AF11	AF11	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=1)/(Team=$AE$11),WL),"")
AG11	AG11	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=2)/(Team=$AE$11),WL),"")
AH11	AH11	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=3)/(Team=$AE$11),WL),"")
AI11	AI11	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=4)/(Team=$AE$11),WL),"")
AJ11	AJ11	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=5)/(Team=$AE$11),WL),"")
AK11	AK11	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=6)/(Team=$AE$11),WL),"")
AL11	AL11	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=7)/(Team=$AE$11),WL),"")
AF12	AF12	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=1)/(Team=$AE$12),WL),"")
AG12	AG12	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=2)/(Team=$AE$12),WL),"")
AH12	AH12	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=3)/(Team=$AE$12),WL),"")
AI12	AI12	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=4)/(Team=$AE$12),WL),"")
AJ12	AJ12	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=5)/(Team=$AE$12),WL),"")
AK12	AK12	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=6)/(Team=$AE$12),WL),"")
AL12	AL12	=IFERROR(LOOKUP(2,1/(Series="Pre")/(Div="West")/(Game=7)/(Team=$AE$12),WL),"")

 

[gtd526]

Do you mean like this?

Sub test()
    [AE5:AL12].Formula = [if(AE5:AL12="",formulatext(AE5:AL12),AE5:AL12)]
End Sub

Works. And faster than the previous 2. thank you.

 

[6StringJazzer]

Works. And faster than the previous 2. thank you.

    [AE5:AL12].Formula = [if(AE5:AL12="",formulatext(AE5:AL12),AE5:AL12)]

Did I misunderstand your requirement?

Only AE5:AE12 should be copy/pasted.

 

[gtd526]

Did I misunderstand your requirement?

I don't think so, your range was just limited to AE12 not AL12...I adjusted your Range from AE5:AE12 to AE5:AL62 so it would look at the entire range and convert necessary cells as needed.
Once adjusted, your code works as it did previously, but I wanted to widen the range.
The Fuji code runs much quicker, maybe the []'s make a difference rather than inspecting Each Cell in Range.
I did mention a wider Range in my original post #1.
The range is AE5:AL12. Only AE5:AE12 should be copy/pasted.