For one of my projects for work I have to add on to a VBA program that
someone else has written. I'm new to VBA and I've learned a lot over
the last few weeks but I need some help with this code. First of all,
what is the format for SUMIF and what does it do? Also, can someone

In Excel, I'm using 2 files (New CU.xls and Error CU.xls) as video
scoreboards. I want to show them at the same time on a single screen space.
"New CU" takes up 80% of the screen and "Error CU" takes up the remaining 20%
as a vertical column on the right.

I have a survey form where users can rate corporate performance.  It is made
up of radio buttons to rank efficiency.  i designed it to prevent closing and
printing if the answers are too skewed (we need 3 5's, 2 4'2 , etc)  It works
fine the first time you open the file.  However ...

hwo do i write this into a VBA code
where i want variable A to be set to 4 if the variable B is greater or
equal to 14
otherwise it is to be set to 16 if the variable C lies between 5 and

Here is some code i wrote to do stats on the data at the bottom.  I
was wondering if anyone could tell me why the program will only alow
for 221 data points to be accurate.  At 222 the algorithm does not
give the correct answer.  In put the data into The input column J.

I have the following code to rearrange a pivot table which by default
includes the "Blank" values in the drop-down for all fields.  How can
I uncheck the "Blanks" option from the drop-down?
Sub ViewbyOwner()

Im trying to apply borders to a series of cells in column P, that starts
in P2, and ends where the last bit of data is in that column. However
there may well be blanks in between...
Ideas?

I am admittedly a novice at Excel so this may be an easy one.  I am trying to
setup a Yes/No question which will trigger the use of different formulas on a
different sheet within the same workbook.  I assume that doing a list box is
the simplest means of accomplishing this goal, ...

My VBA code creates multiple sheets and fills them with data. Each
time a new sheet is created it has default formatting. I have a sheet
that's formatted exactly as I want it, and I'd like for these newly
created sheets to take on that formatting.

I want to prefill a textbox with data from the excel file and I do not want
the user to be able to change the data in this box.  How do i do this?

Hi All.........
I am in need of a macro beyond my skill level, if someone please.  I want to
do a FIND on column A and have a pop-up ask the user for a number to find,
then find it and color the whole row gold, then goto column A of that

Maybe somebody here can give med a little help on the following
problem:
I have a "Master"-workbook containing a lot of data, sheets and vba-
code. From this master workbook I need to control another EXISTING

I have a list of parts in Column A. I want to do a macro to find lets say
beginning 4 characters of the part and when it find to add letter C at end of
the part
Example.

If the macro / code turns out to be an error Then run a different macro.
The code is:
ActiveSheet.ShowAllData
but if it is already showing all then the macro shuts down with an error

I have an excel work book and it has 5 sheets in it namely sheet1, sheet2,
sheet3,sheet4,sheet5. These excel sheets already contain some data in them .
when ever a button in an application is  is clicked  or a function is called
then 5  new sheets(namely sheetA, sheetB, sheetC, ...