Up through Excel 2003 it has not been possible to add a control array similar
to what was possible in VB6 and up.  
Having to custom code for ten uniquely named checkboxes checkbox1 checkbox2
through checkbox10 could be hundreds of lines of code.

I regularly use some files for which I want the cursor to go Down after
pressing Enter, and others where I want it to go Right.
Is there an icon I can set up on a toolbar to allow me to change the
option very quickly ?

I have this file.
12,br2,3er,6ro,WarehouseA,CottonA,Alpha5u4,Brav56o,34g,54inch,$99,45
14,cd3,4er,7ro,WarehouseB,CottonGr,Charlie4,Labmert,45g,55inch,$98,43
15,gd4,5er,8ro,WarehouseC,CottonGe,Charlie2,Labmert,55g,56inch,$97,42

Formula  =IF(COUNTIF(O$7:O8,O8)=1,MAX(N$7:N7)+1,"") is counting the
row index.
This formula is making a list of unique items which I am further using
in a data validation list.

I have many rows with a date column. I am trying to calculate a new column
(Week_Ending) so it will return a date field (every Sunday) that the date
fall in that week using a weekday function, but could not get it to work.
Example:

I manually put the vlookup formula into one row of my worksheet.  It's
working fine.  When I try to drag the formula down to the other rows,
it copies everything except the range lookup.  It just puts #ref where
the range should be.  That has never happened to me before.  Is there

=IF((G5+J19)=G5,0,+G5+J19)
G5 needs to stay the same and cell J needs to keep adding .

Is it possible to use the #N/A error as criteria when using SUMIF?
I'm thinking of something along the lines of
=SUMIF(B3:B32,ISNA(C3:C32)), either entered as an array formula or as
a conventional formula, however, I keep getting 0 returned.  The value

I can not figure out how to get this code to paste special the values only
instead of the formula. Any suggestions?
Sub CopyFindPaste()
       Dim RngToCopy As Range

About some time back T Valko & Gord quite helped me a lot in changing the
gridlines' by default to be to Pale Blue color upon everytime I open the
MS-Excel by using XLStart.
However, the only problem is that while the great idea is working great,

I want to be able to have an excel pivot table that automatically updates
with data once a week after our invoice run.  Our invoicing run, runs from
Sunday to Saturday and but i only require a week ending figure on the
Saturday.  I can do this at the momment by impoting my csv ...

Is there a way that I can count the number of cells in a range that have a
right border?  Can this then be adapted to count either a certain colour
line, e.g. red, blue, black... or failing this a certain type of line, e.g.
dashed, dotted... ?

Hello,
I have a word document containing macros which  run automatically when I
launch the document. Specifically, the macro displays a userform which
prompts the user to enter data that will go into the word file but saves a

Hello   this is my formula =IF(Q3-P3=0,"",Q3-P3)  There are not always
numbers in columns Q and P . so when  P and Q are blank with this formula I
get an answer of #value! .  How can I correct the formula so that if P and Q  
are blank my answer should also be a blank cell  thanks ...

I have 12 spreadsheets, one for each month that has revenue an
employee.  Each sheet/month has 350 or so people and the rev, however
Not all the months have the same people and rev. How do I search the 1
sheets for the names and add all the rev?  Basiclly I want to make