LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default Value cells

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence Excel Worksheet Functions 3 February 13th 11 05:33 AM
compare 2 column cells and return the adjacent columns cells data of the cell trebor57 Excel Worksheet Functions 1 February 1st 11 02:54 PM
join data in multiple cells when adjoining cells match criteria ?? angiec50 Excel Worksheet Functions 1 October 6th 09 10:27 AM
Number Cells skip blank cells, Excel 2000 & 2003 jfcby[_2_] Excel Programming 4 July 31st 07 03:02 PM
Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells Wescotte Excel Programming 1 June 6th 05 07:00 PM


All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"