hello, i am a beginner...Thank you for your help!!
the inner loop was highlighted (compile error), but i don't know what's
wrong here
ps: i want to map the price in J5:J25 to the corresponding cells in

Has anyone come across the following problem? The code below works fine
with Excel 2003, but in 2007 nodes.count always returns zero. Any hints
appreciated!
Many thanks,

I have a database on a worksheet and a userform to search one column for a
text string that the user puts in a textbox. The listbox shows just the
filtered cells.
I'd like the user to be able to select an item in the listbox and view

Does anybody has a macro which would deduct the cell formula of a
selection of cells from original formula.
eg if cell A1= sum(b1:f1)
the macro would leave formula in A1 as : sum(b1:f1) - sum(b1:f1)

I've been follwoing the thread on speeding up Excel & slow performanc
from VBA loops. http://www.excelforum.com/showthread.php?t=572195 
My workbooks are still "Calculating Cells" every time I update a cel
or drop/drag a new formula. I've set Options>Tools>Calculations to th

So instead of seeing #VALUE! the cell will be seen as empty/blank?

Mon       Tues     Wed       Thurs     Fri         Sat    
   Sun
IN                9:00AM  9:00AM  9:00AM      0      9:00AM  9:00AM  9:00AM  
Pantry

Could you please help me with this matter?
I wonder if there is any Excel's formula to do the following procedure:
The column "found" came from a text file.
Number   Call           Test                Found

Does anyone know where objects such as in the toolbox of vba is stored
I have some objects with an extension of .ocx, .cnt, .dep....? I want
to know where to dump them on my hard drive? I would appreciate any one
helping me!

In a C++ COM add-in for Excel I need to do something with all the cells on a
worksheet. I saw that I can use Worksheet.UsedRange. However, this is a
read-only property. Does this mean that the range itself is read-only, or
the cells that are covered by this range (I hope the ...

Can someone give me macro to print all worksheets in a workbook?  Thank you.
Dean

I've written an extensive set of visual basic forms and macros (at least for
me) on a Windows machine running Excel 2003.  I am now in the situation of
needing to use the file and its programs on a Mac running Excel 2004.
The problem is, I really can't troubleshoot the file ...

Back Ground -> I have a workbook that has two tabs (1, 2).  Tab one
will be a user tab for inputting names in column A.  I have (with help
from this group) a function that will create one tab for each one of
the names inserting the name as tab label and making a link from the

Guys,
I have a major problem with an Excel workbook that i created and have
been try to resolve this issue for a couple of weeks and my Bosses are
breathing down my neck.

To get the value from closed workbook I tried a code from following
link
http://j-walk.com/ss/excel/tips/tip82.htm
but the problem is whenever use that kind of code or similar one, empty