What is the best way to make sure I have control overwhen cells are
calculated?
I have some very long running calculations and would like postpone
them until all the pre-conditions are setup.

I have a UDF which, if it can't find what it's looking for, I want to return
and show #VALUE in the cell.  Any ideas how do I do this? Thanks.

I've got a convaluted IF statement:
--
If Variable = 1 or Variable = 3 or Variable = 7 or Variable = 12 Then
--

Can someone please help with this small request.
I need a macro to find the word "intial" in column A and if the word
in the cell immediately below that contains the word "final" then it
should delete both the two rows.

May be it may sound not practical, I try to deal with this issue where
is there anyway such as excel programming which allows to insert a
password protection on a particular folder ( say folder "KT" ) which
consist of excel files in drive "C" ( ie using MS Window XP ) to

I pretty much summed everything up above.
Thousands of rows of data most of which is useless but I thought the
best way to delete would be to find in column A the word "Initial" and
if the cell immediately after is "Final" delete both rows.  If not

Want to use data entry in column (D) as trigger. Depending on data what I do.
There is other data that needs to be entered in this row befor the trigger
should fire. All I have done befor is have trigger fire when data was
entered. Is there a way to delay the action based on the ...

I  have a workbook with multiple worksheets that are all identicable.
However, in each worksheet I have created a data validation combo for the
same specific cell in each worksheet.  The data for the validation list is
set once and every time I select from the drop down list in ...

Can someone help with my visual basic editor layout.
Previously when I opened my visual basic editor the project explorer, the
properties window and whatever module was open be arranged in an organised
fashion. When I maximised the module window it would only occupy the left

I posted this 2 hrs ago but it seems to have disappeared, apologies if
it reappears and this is a double post!
I have an IF statement thus:
--

I'm looking for information about the parameter FieldInfo that is used below:
Workbooks.OpenText Filename:=HelaFilNamn(i), _
                       Origin:=xlMSDOS, StartRow:=1, _
                       DataType:=xlDelimited, _

I think I have discovered an error introduced in service pack 3 for
Excel 2003 regarding OLE linking from a named range.
We have an application that makes extensive use of the uniform data
transfer facilities of OLE (namely we allow users to "Paste Link" data

Is it possible to create a VBA function or subroutine within Excel VBA?
ie: I have a spreadsheet which has a number of functions in it. One of the
functions involves creating a new spreadsheet (in a new file), based on some
of the data in the original sheet. I now need to include ...

I've come up with this formula so far, but it needs to make a loop,I think
with an If statement. Also the string to be found is always in column A.  I
didn't put it in there yet.  Anyone?
Cells.Find(What:="[bestandnaam*", After:=ActiveCell, LookIn:=xlFormulas, _

i have created a excel file with some code in it.... if i want to
distribute it so that the people can use the sheet, but no one should
be able to read the code. One way to do this is by going to project
properties and setting a password. But this wont protect the formulas