Today I was trying to do something - I had a range which contained some
cells containing the text string 'Manufacturer:'  (my inverted commas)
and wanted to format only those cells.
Now, I couldn't autofilter, advanced filter or sort because of the sheet

Is there anyway to automatically update a spreadsheet when my client
updates a different spreadsheet (within the same workbook) and on the
same network.
I need to have a COUNT function to add up the total number of comments.

In VB6 you could get the list separator using the code below.
application.International(xlListSeparator)
How do you do the equivalent in .Net?
Thanks in advance

I'm currently working on a new Excel Tips and Tutorials Blog for
beginners, intermediate and advanced users alike.  I need some ideas
for common problems or tips that people request on newsgroups and
searches on the internet etc.

 I have a Macro that clears any data on different 31 tabs and, due to my
lack of knowledge, I do this one tab at a time.  The 31 tabs represent the
maximum possible days in a month. Here's a sample of my Macro:

I am aware of the possibility to save an Excel document as html, but
this generates a massive amount of html-code.
The program xls2html do what I need where a link between each cell is
created via a template. This would do the trick for me, but

This is a test post. Kindly ignore this.

I want to enter the survey reding in the sheet
    survey reding contain degrees,minutes&seconds
        And iam using the microsoft exel 2003 version

I have a mailing list in .txt format  that I need to open in Excel in
order to clean up and sort, etc.  The problem I am having is that the
list is 76,007 records long and Excel will not allow me to have that
many - I get the message "File not completely loaded" (or something

upon hitting edit--links, there appears a link to:  "E:/testprogram.xls"  i
want to get rid of this link.  additional info:
i have no idea of what this "linked" file is, probably one i used in the
past, but he "E" drive is curious.

I tried to compare the amount of 2 colums (10 rows) because and ithe
are the same amount extracted from 2 different sources.
Here is my function =IF(B7=E7,TRUE,False)
Some rows came out to be True, however, I get some "False" results an

Can I change the order of the columns before/after the creation of the
pivot using VBA>BY order of columns I mean If I have Total Last Year,
Total This Year, Jan2006,Feb2006,...,June2006,July2006 as the columns
in pivot then can I make them to appear as

Hello, I am a new user and I am having great difficulty in figuring out
something. I have a dataset in Excel with first names, last names,
states, cd sales total cost by state... and I am I started a new
worksheet cales total sales y state. Now, in this new sheet I want have

Hey, I had a problem that maybe someone can help me with.
I'm trying to sort a range in a macro. The columns that compose the
range never change, but the rows will. (i.e. columns a:o, but rows may
vary from 26:400 or 26:40)

I created a series of worksheets that included a popup help window.  Now I
wish to change the help messages on a number of cells.  However, I just can't
seem to find the tool again.  It is not the "Comment" tool.  That is the one
that leaves a little red triangle in the upper ...