VBA change format formula to value in column

[Robyrubyjane]

hi guys, so in column X my value have formula, so i want to change the format to value only with VBA. can you help me?

 

[James006]

Is it similar to ...

VBA code SUMPRODUCT

hai, can everyone help me to change this formula to vba code : =SUMPRODUCT(($E$2:$E$63184=E2)*(U2>$U$2:$U$63184); ($F$2:$F$63184=F2)*([U2>$U$2:$U$63184))+1

www.mrexcel.com

 

[Robyrubyjane]

Is it similar to ...

VBA code SUMPRODUCT

hai, can everyone help me to change this formula to vba code : =SUMPRODUCT(($E$2:$E$63184=E2)*(U2>$U$2:$U$63184); ($F$2:$F$63184=F2)*([U2>$U$2:$U$63184))+1

www.mrexcel.com

yes, and I already solved it, this one is different case... in Column X1 is the result of that formula.. and I want to change the format in that X1 cell to value so it is not showing the formula but the value only.

 

[James006]

A couple of remarks :

1. In the previous thread ... you have not indicated that you have managed to solve your initial problem ...

2. The solution you are looking for is absolutely identical in both cases !!! It is the Evaluate function ....

 

[Robyrubyjane]

A couple of remarks :

1. In the previous thread ... you have not indicated that you have managed to solve your initial problem ...

2. The solution you are looking is absolutely identical in both cases !!! It is the Evaluate function ....

I ve tried using evaluate but still it didn't work, so i try another method, I'm using record macro instead.

 

[James006]

Before saying that something does not work ...

why don't you post what you have it tested ... for a contributor to help you out and fix it ...???????

It is exactly what this whole Forum is about ... !!!

 

[Robyrubyjane]

Before saying that something does not work ...

why don't you post what you have it tested ... for a contributor to help you out and fix it ...???????

It is exactly what this whole Forum is about ... !!!

iya