I've an XLS file (1.5 Mb) with several hundred lines of VBA code, that I've
stripped down to one line of code on a single button on a single sheet, that
line is
Crlf = CHR(10)

I need to create a loop to test if the value "56A" exist.  It should loop
until C<25.  If "56A" exists, then call a function.  If c reaches 25 and
"56A" does not exist, then call a different function.
I had this code created.  It seems like both the happy and sad functions are

Is there line/s of code like
if activecell = "" then go here
if not continue code
Thanks

I have created a function that returns a string. When it fails, Excel
reports "#VALUE!". I would like to report my description of the error
instead. I have tried to use error handling, but it seems to be
ignored. In the area in which I "Try to do some useful Stuff", an error

I have a macro that will zip a file using Winzip and then email.
My problem is, when using WinZip 9 there is an option to encrypt th
file but I am unsure how to build this into my macro.
Does anyone have any ideas?

What I'm trying to do is have a formula search column B and then
display the values in column in the order they appear in column B.  Is
there anyway to do this without using VBA?
(See Below)

Hello;
On a w/s, there are a dozen or so input-related cells.  Let us concentrate
on cells G7 and I7.
If I enter or change the value in cell G7, the value in I7 should be

I am experiencing some weird problem with my  list box.
The data is added to the list box dynamically from code using AddItem.
After the entry is added I am selecting it in order to show always the
last entered data.

I'm trying to display on a listbox 3 columns (A1:B100 & E1:E100). On can I
achieved this using the ListBox.Rowsource ?
Thanks.
François

Hi.  I have an excel template that opens a workbook and takes values from it
using the INDIRECT function in cells.  What I need to do now is look at Sheet
4 in the workbook and copy rows only if column B is equal to "CAT" or "DOG".  
Is this possible?

Hi,
See VBA macro below:
The macro is to find the number of marked entities in the list bo
"cboSecondary" which can be found on the worksheet "combo".

This macro just worked, it hid most of my combo boxes and list boxes
However now Im getting an error when trying to select the hidden comb
boxes.... is it not possible to select ( .visible = false ) shapes. Fo
so to make them visable again?

i have in a xls-sheet to rows formated as time (hh:mm)
in each row the entries looks like
08:00   12:00  -> 04:00
11:10   17:10  -> 07:00

we buy goods from several suppliers for export. so i wish to create a
database that can help us keep stock of the goods we buy and how much we have
paid as well as arrears and our current stock.

Hello, I have the following code to delete blank rows within a worksheet.
'Deletes blank lines, for advance filterring
   [a1:a50000].SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Question: Is there a method to delete certain rows, if a particular cell