Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting cells with a particular formula
Is it possible to select all cells in a range with a particular formula, for
instance, VLOOKUP? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting cells with a particular formula
Vlookup returns a string. It doesn't return a reference to a cell. You can
use Match to return an offset into a range, then use that to select a cell. -- Regards, Tom Ogilvy "Muusbreath" wrote in message ... Is it possible to select all cells in a range with a particular formula, for instance, VLOOKUP? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting cells with a particular formula
Thanks, but let me be more specific:
I have a column that uses to VLOOKUP to get values from a trial balance. The same column has subtotals (SUM). I want to select only the cells with the formula VLOOKUP so that I can copypaste specialvalues leaving the SUM formula intact. Thanks for your help. "Tom Ogilvy" wrote in message ... Vlookup returns a string. It doesn't return a reference to a cell. You can use Match to return an offset into a range, then use that to select a cell. -- Regards, Tom Ogilvy "Muusbreath" wrote in message ... Is it possible to select all cells in a range with a particular formula, for instance, VLOOKUP? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting cells with a particular formula
Dim cell as Range
With Worksheets("Sheet2") for each cell in intersect(.Columns(6), .UsedRange).SpecialCells(xlFormulas) if Instr(1,cell.Formula,"vlookup",vbTextCompare) then _ Cell.Formula = Cell.Value Next End With -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Vlookup returns a string. It doesn't return a reference to a cell. You can use Match to return an offset into a range, then use that to select a cell. -- Regards, Tom Ogilvy "Muusbreath" wrote in message ... Is it possible to select all cells in a range with a particular formula, for instance, VLOOKUP? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for selecting cells in one table from values in another | Excel Worksheet Functions | |||
How to change shade of cells when selecting multiple cells | Excel Discussion (Misc queries) | |||
Selecting cells with certain formula? | Excel Discussion (Misc queries) | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
formula for selecting all cells | Excel Discussion (Misc queries) |