I have a large Combobox and i have populated list in it.
A few of the values are a bit longer than the others.
I do NOT want to lengthen the Combobox.
But, Is there a way to have the Text Wrap??

I'm coding a macro and want it to copy existing sheets as an array into a new
workbook, then I want to edit the copied sheets in the new workbook.  I'm
having trouble with the code, I've got the below, but don't know how to
activate the new workbook for editting.

I am trying to total a range that is filtered to "X".  My problem is
the range ("x"'d items) will change with new data.  I was able to count
down to the last cell and execute a subtotal but it is a specified
range.  Is there code I can use that will allow the range to be dynamic

I am VERY VERY VERY new to VB programming.  I am looking to import all
5 text files from a folder and then sort them into 5 separate columns
in my workbook starting at A43 for the first file, B43 for the second
file, etc...  5 new text files will be placed in this folder everyday

I have a list of students names in columns with their run time and
other physical tests along the row.  The sheet uses a vlookup table to
calculate their scores and from their scores, determines if they pass
or fail and if they pass, if they are to receive a fitness pin "Y".

Whenever I add a control (i.e. checkbox, command button, etc) from the
Controls Toolbox to a worksheet, the font for the text on the control
is distorted, in that it is slightly elongated and pixelated. If I
click on the control, the font returns to "normal" appearance, but once

I need a macro that will SUM the cells in rows that vary in the number of
rows and put the total in the column next to the last number before a blank
row. It will then go down the column until it finds another row with a number
in it and SUM those rows until the next blank row, loop ...

question to the all the smart Excel brains out there. I have a chart
whose X-Axis displays dates for the year 2006. The dates are formatted
as "General". The chart does not display more than 9 digit dates. This
means that the date "1/12/2006" is displayed fine, but the date

The below code was placing a chart on the activesheet by calling data from
that sheet.
But all of a sudden i now get an error.
The only thing i have changed in the workbook was a code for protecting and

I have a pivot chart in which all the bars are the same color.
I would like to change the color of the bars based on my own criteria.
Any suggestions on how to change the formats for the bars individually?
thanx

Hi.  I currently have a program that creates a pivot table.  I want to create
another pivot table that keys off of the same data, but would like to use the
"cached" data rather than re-use the same data.  I have the second pivot
table command below.  How would I rewrite this to ...

I'm a newbie with excel programming, but can somebody help me with the
following.
I have a rather large worksheet from wich I have to change the row
height to 15, but only the rows that have a height of 13.75.

i'm trying to make this run automatically -
it was originally part of a demo written
by Andy Pope where the userform was
already showing & you had

I have a problem with macros.  I have a macro that used to work as
desired, and now it only works the first time Excel is opened, then it
doesn't run at all:
Sub RemoveLetters()

Dear Reader
How to check drive exist or not using  FileSystemObject ?
Private Sub cmdSelectName_Click()
   Dim myFileName As Variant