I have a salary amount that I must examine against a salary matrix.  The
salary matrix has a lane and step number that allows me to use the index
function.  I must examine the matrix and return the lane number needed for
the salary amount to be equal or greater than the given ...

Hi to All,
I used the Tools > Customize command to create some custom button
buttons which I placed on an existing toolbar and assigned macros
to.   After closing Excel and reopening the buttons vanish every

I'm trying to think of a way to "sort" or "match" two columns of cells based
on if the values of the rows are equal. For examle, LISTING 1 below shows
cell B2 equal to 196650. I need a way with code to "sort" or "match" that
value with it's equal in column A. So my results would end ...

I have a custom C++ excel function. When the function's output is a
number, I want to format it with commas in 1000s and right justify in
the cell. I get return code 2 when I try using
success = XlfExcel::Instance().Call(xlcFormatNumber,0,1,xFormatNumber)

Hello Expert !!!
I would like to run a macro to validate if the cell is not empty and
copy the related lines to another worksheet.
Example :

I am new to VBA and have inherited a spreadsheet with to folloing code
lines:   Can someone give a good idea what the mean?   Where is the
best place to look this kind of stuff up -explinations of code etc.?
Thanks in advance.

I have the below macro and am having a slight problem. The macro PDFs
the document from excel and saves it accurately. However, the document
PDFs portrait style instead of landscape. While it seems easy to
rotate the document, I have hundreds of PDFs that automatically go

I want to popup a shortcut menu whenever a user right clicks in a textbox on
my userform.  I initially tried to use:
ctrl = Screen.Activecontrol  'this is how I would do it in Access
but this did not work.  Since I have several userforms, and I want this

I am new to excell 2007... I am trying to unlock passwork protected modules
and don't know how to launch VBA (since I cannot step into a locked macro).
Second... any suggested reading to update me on excell and VB 2007?

I wanted a Multiline Messagebox in VBA.
I tried the following code but an error ("Object Required") comes.
MsgBox ("Some text" & ControlChars.NewLine & "More text")
Is it because of the .newline?  How can I get a multiline msgbox?

i have copied the code from cpearson.com/excel/colors.htm which allows you to
sum a range of cells by color.  this worked fine in one spreadsheet but when
i copied the same code to another spreadsheet i get a NAME? error.  any
suggestions?

I'm trying to get the last column of a range. I copied the line of
code directly from a Dave Petersen post in this NG and substituted my
range variable and column variable. But I get an Obj var or with block
variable not set. Both variables are declared and the range has been

 I am making an Excel database of all my friends and family so that
next Christmas I won't have to go find all of their addresses again.
I would like to figure out how to put a "print envelope" VBA button on
my Excel page.  The button would take the appropriate cell values and

I am trying to select a columns that are hidden in sheets 1-10 and then
unhide them.
Below is as far as I have gotten. Selecting the sheets and columns appears
to work fine, the problem appears to be in activating said cells in order to

Trying to write a formula to go to first worksheet look if there are
any numbers or words and if not go to next worksheet and do the same.
If both are empty, then the cell should be left blank.  If one or
other has info then that should be result, if both have info then put