how do i get vba to look at a cell value, rather than the formula that creates the value?

Question

I am using vba with excel and I'm trying to write a formula that hides all rows with values of FALSE. However, when the macro searches through the string it looks at the formula and therefore finds no FALSE cell values despite the sheet being covered in them. I can get this macro to work with numbers but not with text.

Answer 1

You are using macro to record your find action, right?
If so
In your Find command line in your macro search for the text that says
LookIn:=xlFormulas
and replace it with
LookIn:=xlValues

Your line may be looks like this
ells.Find(What:="false", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate

So just replace the text in above line from "xlFormulas" to "xlValues"

Enjoy my profile, I am the VBAXLMan

Answer 2

1

Answer 3

I just tried loading some number in cells and using an if to place TRUE or FALSE in next column...

Using the following in VBA in the sheet activate event
Cells.Range("C6") = Cells.Range("B3")

I had no problem copying the computed value of FALSE into cell C6

Perhaps if you could share a little more details on your code would be helpful...

Answer 4

Highlight and copy the column, highlight a blank column and do a paste special (not just paste), click on values, and paste. You should be able to work on that new column.

Answer 5

cells(row, column).value is the correct coding

Answer 6

Use

cells(y,x).value