Someone on this board was kind enough to write the macro (user define
function) below for me. Its purpose is to search for file names in
desktop folder and return a true or false depending on whether or not
match is found in the folder.

HI, Is it possible with worksheet change to fill a vba array and retain
those values in the array with pasting back to a worksheet. What I meen
is, Cell changes in worksheet, Change fired, my array = 1, end sub,
back to worksheet, cell changes, Change fired no myarray = myarray + 1.

I need to format a column to show only minutes and seconds in the 31:12
format. It must force the data to conform so the interns will not screw up
the table. I have tried all the options with none working. The format [h]:mm
works but the formula bar shows

I have a Combo Box (added through the Control Toolbox) that I want t
be mandatory, i.e. it must always contain one of the values reference
in the ListFillRange.  Currently I can select one of the values, but
can then overtype it with something else not in the list, or remove i

It would be much easier to navigate spreadsheets within a completed workbook
if there was an option to view the spreadsheet names in a column to the left
of your screen.  (Like the document map feature in Word).  I work with
workbooks for my employer daily that have more tabs ...

Hello - I am trying to generate a report based on some usage reports. I
have three columns, one with user names, one with usage description and
the final with corresponding usage quantity.  Some of the usage
descriptions are synonymous so the usage quantity will be a sum of

Question: Is there any way to set the formatting once (e.g. for row height,
and column width) so that when I transfer data into 100 or so different
user's sheets it all looks the same?  I am trying to avoid cutting and
pasting the 20 or so lines of column/row formatting into the ...

Not sure if anyone can explain why I'm getting a run time error '91'
(object variable or with block variable not set) when I try to run this
nested loop - I'm out of thoughts in trying to troubleshoot it.  Any
thoughts would be greatly appreciated!

I want to delete all rows that do not contain the numbers 1, 2, 3 or
in column A. (some column A cells have letters and some are blank thes
are the ones I want to delete) How can I do this with a macro?
Thanks!

I need to programmatically add codes to a sheet module which has been
renamed previously.
Let's say such module's internal name is Sheet8, but the sheet has been
renamed as, say "ABCDE".

Let me first start off by saying hello.  I am a long time browser o
this board and today I registered.
I have an excel spreadsheet with student ID numbers and scores fo
various tests.  I have looked at the microsoft templates as well a

I need help with a macro. On my workbook I have two Worksheets.
Sheet1 is were I keep the form.  Sheet2 is were the data is transferre
when I run the macro. The macro I have built works fine in transferrin
the data from the form (Sheet1) to the table on sheet2. I also have

When calling a function created in a different workbook, I get the #NAME! not
defined even thought I put down the spreadsheet name.
"=anotherbook!myfunction(A1)"
Am I doing something wrong?

I am trying to run a custom filter on a column, returning results if any of
three values are found in a cell.  
For example, if "MO" or "TU" or "WE" are found.
However this function will not support more than one 'OR' in the code.

I have a named range "myCells" (one column)
I know there is a function to mark jsut blank cells in Excel, however
haven't found any function to mark all cells containing some kind o
data.