software

What code do I need in a macro to determine whether a sheet is protected or
not?

Is there a macro that will display ONLY the comments in the workbook or
worksheet?Hi Maural,

I have eight worksheets in a workbook. The worksheets contains columns of
numbers with a total at the bottom of each column. Is there a way I can add

How do I create an organization chart from an excel file that has a quot;reports
toquot; column. The quot;reports toquot; column indicates the hierarchy of who reports

i have 3 colums columns (date, cash and check)

How do I omit a cell that contains a negative number in an addition formula?
I can't use sum because there are cells in between.

I have a weather station that outputs a text file with two columns, one with
a 4 digit year, and another with the julian day. I need to convert the

Hello,

I have a spreadsheet and am looking for some assistance to make a conditional
format to produce the following:

Greetings,

When I insert word Art in Excel sheet, the following message appears and
excel file will close automatically.

Hi All,

Hello

I have a column with a drop down list:

I am using vlookup to return data for a particular reference number. If the
reference number is not available I would like to replace the #N/A returns

I'm hoping someone can give some pointers to a pivot table newbie.

In my Vlookup function I want to use 1 or 2 cell refernces as a text string
to give the name of my table array.

when I use, ActiveSheet.Pictures.Insert(stringVariable).Select , I

Is there anyway to make the quot;zero and negative numbers cannot be plotted in
log plots...quot; error message? It is really annoying as it goes off every 5

Need to build a spreadsheet that can be used to grab network stats from the
ping or other programs and out put them directly into excel. I'm sure there