VBA to make the formula to value

**shiva_reshs** · 07-23-2019, 05:10 AM

Hi,

Is there a way to make the data appear in values and not in formula?

Please Login or Register  to view this content.

i am aware of .value = .value. But what i am trying to do if there is an alternative to FormulaR1C1 ?

**sintek** · 07-23-2019, 05:35 AM

Something like this...Untested...Not sure what the lookup criteria is...

Please Login or Register  to view this content.

**shiva_reshs** · 07-23-2019, 05:52 AM

Thank you sintek.

I tried, but am getting error msg as Runtime error 1004, Unable to get the vlookup property of the worksheetfunction class.

Please Login or Register  to view this content.

**sintek** · 07-23-2019, 05:56 AM

Please Login or Register  to view this content.

remove quotation marks
And this range not correct....

Please Login or Register  to view this content.

2nd column in only 1 col range...

**shiva_reshs** · 07-23-2019, 05:58 AM

Did. Still same error msg.

**sintek** · 07-23-2019, 05:59 AM

Upload your sample file...

**Marc L** · 07-23-2019, 06:03 AM

Originally Posted by shiva_reshs

if there is an alternative to FormulaR1C1 ?

Yes just using directly the formula ! [D26].Value2 = [VLOOKUP(D2,DATA!$A:$AX,26,0)]

**shiva_reshs** · 07-23-2019, 06:08 AM

Thank you Sintek and Marc for helping out. Solved.

**sintek** · 07-23-2019, 06:17 AM

Glad you got it sorted...
Long way you get not figure out would have been...

Please Login or Register  to view this content.

Re: VBA to make the formula to value