Hi all, i have a variable length of spreadsheet with columns N, O & P
with names in. There will never be two or three names next to each other
but there are instances when all 3 will be blank ijn the same row, these
are the Rows that i would like to delete. Could somebody help with ...

I am trying to write a macro that will save the current spreadsheet in
a unique directory depending on an input supplied by the user.    In
this case the user will input a month number.  If they input "1"  the
macro will save the file in a directory named "Jan".  If "2" is

Hi All,
I have several macros (self published) that I have run in Excell 97 all the
way through 2003). These are very basic macros create with the recorder. When
I upgraded to 2007, none of the macros will work. They are blocked with

I have a form which the user inputs values into various text and combo
boxes.  When finished adding all information on teh form, the user clicks
submit, and the values are transferred to a sheet called 'HQ Input'.  Each
row has a month field that the user selects from a combo box ...

Actually, it may not be a challange for you, but it is for me...
I have a worksheet that I am trying to clean and combine records.
In essence here is have I have:
ColumnBC       ColumnCO    ColumnCR

Hi! I have problem with a piece of code that I don’t understand. It is udf.
It works like this: it takes three cells as argument (although you don’t see
that in the code). I then check the contents of those three cells to see if
they match two arrays that you can see in my code. ...

I'm trying to write a small utility to convert names of days and months from
English to another language.  
I have a form with four multi-line text boxes (FromMonth, FromDay, ToMonth,
ToDay), a "Translate" button and a "Cancel" button.

hi! I have a udf that uses a help udf. The main udf reads one or more ranges
and then sorts through them with the us eof the help. it returns a single
value (eg. AA+). The code works just fine but I had to change it because if
the cells that are taking in as argument are not ...

How do I get my dropdown (done with Data validation) to jump to the section,
I have around 2000 entries and I need it to work so that if I hit "S" it
jumps to the sections starting with that but if I type "sol" it will go to
entries starting with SOL.

This is probably simple but not obvious to me.  I'm working with the VBA
editor in Office 2002.  Some option has been set so that the editor is
continually resolving the syntax of what I'm typing.  The result is that if
I'm typing a space and then pausing, the space collapses, ...

I want to protect sheet because I have some formulas that I don't want people
hace access to it to modify. But I have some cells that people will enter
some values and they give a message and change the cell color depends of the
value that they enter. My problem is when I protect ...

I have a sheet that when protected, greys out the decimal place
setting buttons up top of the sheet on the menus. Is there a way of
having the decimal place buttons usable when sheet protected?
Cheers,

We have several different "Forms" that field agents complete, part of the
completion process is having the form emailed to the office.
Somewhere a macro automatically takes these attachment forms and saves them
into a folder.

I have an web application where user can export the results of search action
to an excel file so he can locally store it.. I have done this with very
simple code which is
           Response.ContentType = "application/vnd.ms-excel";

Hi can anybody help me with this problem:
I have a function that expects  the following:
Public Sub CheckFrame(ByRef ThisFrame As MSForms.Frame)
I would like to call this Sub in a loop foor frames with names FrameQ1,