• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Replace formula with value

Busymanjohn

Busymanjohn

Member
Hi all, I am trying to replace a vlookup formula with values but ignore hidden rows, so leave the formula in the hidden rows, e.g. a vlookup formula in cols a -d and rows 1 -10, i have hidden rows 4 - 6 as i want the formula to remain, but wnat the formulas in rows 1-3 and 5-10 replaced with their values. Is it possible? I have tried using the Visible Cells Only trick, it doesn't work right. Thanks
 
Simple file added, I have hidden rows 4-6, i want to keep the vlookup formula in there, but want to replace all other unhidden cells with the values and not the formulas, e.g. Cell C2 would shows a value of $125 and not the vlookup formula. Thanks
 

Attachments

I am trying to replace the vlookup formula with their values, .... the vlookup returns the value correctly, now I want to replace the formula with just the value, so no formula at all ( except those in the hidden rows ).
 
Did Your ok mean that You're looking for formula solution based Your chosen forum?
... or ... is VBA ok?
This sample would do ... as You've written ... but I'm wondering
... why do You need formulas with hidden rows?
I have done only rough test with this sample.
 

Attachments

You must log in or register to reply here.
Back
Top