Is there a way I can change the font colour to red in the entire row
based on a value in a cell using an IF statment without using the
Conditional Formatting ?
Thanks,

I want to change the color of selected Tab at run time. With static Excel
Sheet I know I can select the Tab(Sheet NAme), right click on it and change
the color. But how can i do the same thing programatically?
Thanks in advance

Folks,
I created a new VSTO Excel project, put a MessageBox in the WB_Open event,
and hit the 'Debug'. Excel tried to load, then went south.
When I open the workbook outside of .NET, the workbook opens and the

Can anyone send me an efficient VBA multi-dimensional (2-D or 3-D) for
finding the nearest neighbors to each point in a set of points?
Thanks.

Is there a way to view data on at worksheet with a form? I want
something similiar to the Data, Form found on the spread sheet toolbar.
I need to be able to view each record and add a record if needed.
Thanks for any help you can give.

I am creating a table in which we are inputting our test results and
comparing them against the standards.  I have conditional formats on
the empty cells where we input our data that if it exceeds the
standards, then the cell is shaded gray and the text bold and

I would like to copy each row of sheet "Raw Data", colunms A-N, that has a
"T" in column 'R' onto a template on another sheet.  This other sheet is
titled "Input Table", and I would copy into these same columns.  
The number of rows in "Raw Data" could be up to 25,000 rows, and ...

I want to add Wrap Text to one of the cells in my excel spreadsheet.  I am
creating this file using asp.net (vb.net).  Thanks.

Is there a way to (using an escel VBA macro) search for a filename and
return its path?  THe file I am looking for will always be the same,
but could have a different path from machine to machine.
THanks!

When UF4 comes up, the user enters the PO# in TextBox1. If this PO# is
already on the list, a message comes up letting the user know.
It is suppose to then unload the UF, then reload it. I wanted the UF
unloaded instead of just clearing TextBox1 in case the user entered

I need to go through each record one at a time to convert RTF to Text from
SQL. The code I currently use is the following. My problem is that I cannot
define the rstRecordSet!strFieldName like I'm doing it now as I receive an
error. Is there any way around hard coding each ...

(sorry for my poor english) :-))
I copy a lot of tables in one to resume (it works) ; all areas have the same
structure (from column A to K) but not the same numbers of rows; the grand
total varies from 200 to 500 lines; i would like, after the copy, to place

I have an Excel worksheet of 750 entries, one column being names in the
format of Last, First Initial.  This worksheet changes daily as
projects are being cancelled and added.  I need a way to change the
names into email addresses.  I do have outlook at my disposal and it

it is possible to link a chart title to a cell via vba macro:
Sub Makro2()
   ActiveSheet.ChartObjects("Diagramm 1").Activate
   ActiveChart.ChartTitle.Select

I´m triying to assign a value to next cell (+ 1 column) of active one,
but doesn´t work in this ways:
Cells(ActiveCell.Row, ActiveCell.Column + 1).Value = "888"
ActiveCell.Offset(0, 1).Value = 2222