When you bring up the function wizard, you can select functions by Category
(Financial, Date & Time, Database, Text, etc).  How does one assign a
Category to their custom (VBA created) function so it will show up in the
appropriate Category?

I have a userform that has a combobox for car makes, and I want to make
it so that when a make is selected, the box below it will be populated
with the models of that make.
I already have the makes populating the make comboboxes using ADO on

does anyone have a formula/function to extract numbers from alphanumeric
strings?
the numeric portion of the string may contain both leading and trailing "0"s
as well as "-"s; (spaces would not be part of the numeric portion, however

Can I print variables in VBA directly, without storing the values in cells
and printing the cells ?
Thanks for your help

I'm trying to use a refedit in a userform, but strange things are
happening. The user selects a range in the spreadsheet which is
supposed to be caputured by the refedit (reDataStrt) and saved as a
variable. I've tried doing it by having the range selected stored when

Anyone know of a method for programmatically disabling ALL auto cell
formatting?
For instance, if Excel detects cell content that looks like a date, it will
change the NumberFormatLocal property for the cell to a custom date format.

I need the data in column C to be highlighted when rows begin with 'ign' and
'leg' in column A and have identical ID codes in column B.
Here is a 'cut and paste' from the worksheet (The XXX is just placeholders
to demonstrate; and the spacing between the rows is for clarity).

I am using this formula to pick data and do a count, however when I use the
letter N it comes back with an error. I can substitute N with A and get the
proper result I am looking for, however I would like to use N for Navy.....
Any help would be great.

sorry hit the wrong button.
I'm pulling a part of a string from one cell, and putting it in another.
I've got the method working, except one problem. In some instances the string
that's being pulled is all numbers. In these cases it's getting put into the

Trevor Shuttleworth kindly wrote this formula for me:
A1=300
A2=g
300    This weight 300 is in g

I have a macro below that will merge all the xls files in a directory
into one excel file.  What I want is a slight addition to my macro to
bring into cell A1 the filename of each so that I can show a clear
distinction between the files being merged into one sheet.

I have data in cells A1..L1.  I have a condition (A,B or C) in cells
H30..S30.  Cell A1 corresponds to h30, B1 to I30, etc.
I need a routine that will copy and paste the data down 6 rows based up on
the condition. So for each cell in H30..S30 that has A in it, the routine

I am having a lot of trouble trying to figure out a way to formulate a
spreadsheet to automate my retail markup process. Here is what I am
trying to do:
Let's say for items costing me $1.00 I would like to have a 500%

i have an autofilter set. i need to sum a column to the right of a column for
each change in a letter.
i am using a for each cell in range.SpecialCells(xlCellTypeVisible) and i step
through the cells ok, but when i try to get offsets to add them up, i get hidden

I have just started trying to do some VBA for Pivottables.   I have recorded
some macros and have a good reference book but for I don't undersand what
ALL;TOTAL refers to and are there other parameters I can use there?   If so
what are they, what are they called, what should I ...