I'm working on a spreadsheet for a student tournament and having
trouble with the code to break ties.  In the tournament there are 3
rounds and may be mulitple sections per round (usually 2, but maybe
more) - each section would have up to 8 students.  The students are

I have a set of data which starts at C22.  there is data in the cells
around this, but I am only interested in selecting the range C22 and
all cells containing data to the right and cells containing data below
cell C22.  I have used xltoright and xldown before, but can't seem to

Is it possible to get the width of all of the visible columns?
Would this work?
   Worksheets("Sheet1").Activate
   Windows(1).VisibleRange.Width

I've got the following code which I am trying to add the following 2 columns
thru cell refences and am getting a compile error. I am not sure what I am
doing wrong since it works when I only reference 1 column.
Worksheets(Sh).Range("W" & X).FormulaR1C1 = "=((RC[" &

I need to create a formula that will figure out comissions & bonuses based on
not only amount sold, but also based on how much of each product is sold.  I
have the breakdown as follows:
Percentage to Goal    Total Revenue Bonus    Online Only Revenue Bonus   

I am going to be processing some large files and I would like to dispaly what
file I am process but I don't want the user to have to click on a button.  I
would like the box to display all the time.  Is that possible to do?  Where
do I start?

I have DeleteSheet code at the end of my macro and the box always pops asking
if I want to Delete the Sheet.  What is code to make it automatically close
or = True?

I have a worksheet LOADED w/ info; I have created a UserForm with a textbox,
commadButton and a listbox. When i type a criteria in the textbox in the
information appears in the list box. After a good while I notice more the one
occurrence of said criteria how do I modify the code ...

I have some code that sizes and centers an image in a target cell.  This
works great in Excel 2000 and 2003.  Unfortunately, it only does 75% of the
job in Excel 2007.  The scaling and horizontal position are good, but the
vertical position is slightly off.  Is there some ...

I have a standard chart and data on several files, 1 file for each product.
The data for each file is imported from Access. I created a master file which
link the data from each product file. How do I create a macro to go to all
the product files, to refresh all the data which in ...

Hi everyone.  I have a data sheet that 14,000 rows long.  In column A
is the customer number.  Then I have a "control" sheet, where I have a
list of customer numbers to pull (copy) from the data sheet (A3:A20).
Can VBA scan the data sheet, create a new sheet for all entries in

I am happy enough writing macros but want some help to ensure I can
write the one I want!
I have a spreadsheet with pupil details in columns A-C, and then
currently in columns D-AA I hold marking details for student progress.

I have an excel sheet that as a number of rows on it that I want to group
together.
On the end of these rows I have put a calender. Is their anyway
I can group half the row and not the whole row as it takes out a number of

I am trying to fill a range in Column E, where there is data in E5 & E10, and
I wanted to be able to auto fill down, but only the blank cells.  I wanted
the last row in Column E to be filled down to the last row in Column A that
is used.  My macro doesn’t seem to do anything.

How do I create a macro to do a File Open and default to the 'My Documents'
dialog box?
Thank you,
Steven