Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet that is using an excel addon program which uses a function
=DBR( , , , ). The =DBR() occurs for example 100 times in the worksheet will be in different columns and is not continuous cells. My question is that if I another person wants to see the worksheet the =DBR() functions must be Valued because they do not have the addon on their machine and we do not want to purchase addition licenses to put it on. Question: Is there a quick way to tell excel to value any cell where it sees the =DBR() function. I had made a routine that started at A1 and tested the cell to see if it had the =DBR() function and then it would value if it was true and then go to A2 A3 down to A200 then to B1....down to B200 then C then D, E , F , G, H, I, J until it had tested to J200. But that is a bit cumbersome. I was wondering if there is a quick hit method I am missing. Thank you for your help. Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
join data in multiple cells when adjoining cells match criteria ?? | Excel Worksheet Functions | |||
Number Cells skip blank cells, Excel 2000 & 2003 | Excel Programming | |||
Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells | Excel Programming |