Similar to an earlier post (noted below), I've created custom command
bars with associated macros pertaining to the data on a specific Excel
sheet.  In other words, I want to see only the toolbar containing the
commands pertaining to the sheet when a sheet is selected.  Here is

I am new to programming in excel so please bear with me.  I am trying
to write some code to automate the external data import of multiple
files.  I have recorded the following macro to give me some idea of
where to start but i need help on how to finish

I have been banging my head against the wall trying to figure out how to use
parts of a range for an udf.  I am trying to merge Index and Match into one
function where there is only 3 inputs.  The point of this is to trim down the
over head.  My thought was that if I could difine ...

In Excel 2003 what do I need to change in this piece of code to only copy
values?
ThisWorkbook.Worksheets("source_sheet").Range(Cells(Jour_Rw, 1),
Cells(Jour_Rw, 18)).copy

Maybe someone can tell me what I am doing wrong.  I wrote the
following Macro and it appears to run correctly, however when I assign
it to the command button, nothing executes.  The button clicks but
doesnt take you to the assigned sheet.  You help is much appreciated.

I used the following code to get the name of a cell:
dim a as string
a = ActiveCell.name.name
Can I do something similiar to get the name of a range of cells?

If I set watch points for Params and SubParams below, I find that
Params has one dimension but SubParams has TWO:
 Function Func(ParamArray Params) as String
   ... = SubFunc(Params)

I want to delete any (all) textboxes in the activesheet. This is what I have
got so far:
For Each Shapes.TextBox In ActiveSheet
  .Delete

In Excel 2003 I have a specific sheet where the validation list does not
appear (arrow button gone) when set. I can set it up (Data/Validation menu)
as usual with out problems. The other sheets in the workbook do not have this
problem.

Hi!  How would I write into my code to look in cells in column one for a
specific number and then divide by 25.  Here's a sample of the number:
col 1                        col 2        col 3
02.3892.067.033     descrip.    2025

I have a List Box populated by Rowsource A3:I600 -I need to renew
information in Columns J :Q whilst viewing the list Box on the UserForm. I
would theefore see in the Textboxes all the data A3:I3 -- I can then fill the
TextBoxes for Columns J:Q click the CommandButton and the ...

I am looking for a function that is a lot like SUMIF function but is Min if.
Returns the min in a range by criteria.
Range, Criteria, and Min range
Any help would be great.

I am looking for a function that is a lot like SUMIF function but is Min if.
Returns the min in a range by criteria.
Range, Criteria, and Min range
Any help would be great. Example below

Currently, I am using
Workbooks.OpenText Filename:= "ftp://username:password@ftpservername/
directory" & (some other parameters)
to connect to a ftp server to download files that will generate my

I have a workbook that opens a new instance of excel and i need to
freeze a row in it. The problem is i've no idea how to set the new
excel application to be the activewindow so i can freeze the row. Any
thoughts?