I am writing a custom macro and have a very basic question... I want to
locate a certain cell by seraching for a specific word and then automatically
highlight a range of cells under or next to that cell.  I can do this
manually by Searching for that keyword (which locates the ...

KISS : keep It Simple Sam. This is a revised request to help on a
period solver to schedule lifts
You have a tank that contains liquid. You make liquid each day at some
rate. The tank has to hold this  daily make. Tank has a max and a min

I have an excel spreadsheet with thousands of entries in it down just
one column "A". My question is, how do I find just the cells with less
than 3 or 4 characters in them and with or without numbers also?  Is
this possible?

Is this a bug or my misunderstanding with date VBA functions: DateDiff
and DateAdd:
The DateDiff function returns always an integer, which I suppose mean,
that between 2 dates there is at least full period of difference. In

Corey.....a few weeks back you helped me try to stop certain cells from
being protected...............Dec 12th 2006 13.09
I can't quite get it to work.........................
Ive got a large-ish sheet open but only want to allow certain cells to be

I want to find the cells containing a Formula.
I assume it will be Excel4(xlfFind, ........)
Can you please tell me the exact arguments?
Thanks,

I want to find the cells containing a Formula.
I assume it will be Excel4(xlfFind, ........)
Can you please tell me the exact arguments?
Thanks,

To put the quetion simple: Is it possible to design Excel Funtions similar
to the MMULT function using exclusively VBA.
Thank you for any help

Excel 2003 all sps loaded
OS: Windows XP
I can find the modules that are macros in my Excel workbook by loading the
VBA editor.  However, I can not find how to delete these modules.  There is

I have 10 sets of data (i.e, 10 series). I have to plot this data with
two different Y-axis types: left side with StackedColumn and right sie
with StackedColumn100 types.
For this first I have plotted all the data. Created one dummy series

A common problem I find is that the very useful D* worksheet functions
require two rows in order to specify their ctiteria.  This is fine
until you want to put on on every line in a big report.
For years I've put up with this, but recently decided to write my own

Hi all!  I am a new poster and also a neophyte Visual Basic user.  I am
trying to create a macro that will cut the odd ranges in (B9:B649) to
(A9:A649).  There is data in the even ranges I will want to move up in
column B when I get the odd data moved to column A.  I've seen a lot ...

I am having problems with a very simple routine I have done before.  None of
the the three commands works in this code (1-delete modules, 2-delete
multiple sheets, 3- have no alert flash when deleting).
Sub test()

Can a printer driver or video card effect the way excel displays and
prints out spreadsheets?
I have tested the same spreadsheet on different computers with
different printers.  The spreadsheet prints out differently on some of

Can anybody recommend me a good VBA book for Excel by name and author.  I am
looking for an outstanding book that talks all about FileSystem, Functions,
etc.  I know I may have to order this in a book store.  All the VBA book I
could fine touch VBA very lightly.  I just looking ...