I have a simple data entry form where users are requested to type in a
description of work performed.  I want to limit the amount of text they can
enter and would like to display a "live" counter that tells them how many
characters they can enter.  This counter would decrease as ...

I want to do something like this...
1st worksheet name "targetTab"
2nd worksheet name "sourceTabA"
3rd worksheet name "sourceTabB"

My students need to install and use some of the standard Excel add-ins,
but some cannot find the required install disc. Is there a way to do
this without the install disc?

Suppose, I have a two (or several) columns with numbers. I want to
analyze two or more columns in a different way, for instance I want to
know the growth in percentage and probably have some visual
interpretation (i.e. arrow up or down).

Hi, I have two workbooks, exactly the same, on two different computers
and both have to be updated. Updating takes place by two different
people. My problem is that when I try to update the one on the other
computer, the user has left it on and I get a read only file and vice

Hi, wonder if someone can help me with this problem.  I'm trying to build an
addin that lets users apply one of six different color palettes to
individual worksheets in an excel workbook.  It's easy enough to get this
working such that a color palette can be selected for the ...

I have a column of numbers (2100 to be exact) that I need to insert dashes
so they resemble 333-33-3333.  The numbers currently show 333333333.  Is
there anything I can do?
Thanks so much for any suggestions..

I just got an email from one of my financial newsletters about a
portfolio reallocation  "selling ... reducing its exposure from about
17%
to 6% of assets. In turn, we will use the proceeds to initiate a new 11%

I try to do
convar(A1:$A$10,$B$1:B10)
convar(A2:$A$10,$B$1:B9)
convar(A3:$A$10,$B$1:B8)

I have a Excel (2003) workbook consisting on 4 sheets, sheet 1 has 9
columns, sheet 2 has 4 columns, sheet 3 has 2 columns.
Sheet 4 is used for new data which will usually stay on this sheet for a few
weeks before I manually copy it over to the relevant sheet then manually

I am working on someone else's spreadsheet which has a new pull-down menu
with the print function on it which enables printing of all worksheets
simultaneously. How do I remove it? I have tried going to Tools, Macro,
Macros but when I click on the macro name (print), the delete ...

Using Excel 2000 with XP
In my worksheet, when I use to enter text in a cell the edit line showed
this prefixed with an apostrophe, however this has stopped and when
importing data, I can't easily identify whether an entry is a numeric or

I want to put two (or more) lines of text in the same cell.  Like
    Network
    Command
Is there any way to do that?

Okay, this is a tough one... (At least for me)
I'm using the hlookup formula to import the starting times and ending times
of employees on a daily assignment sheet.  I'm compiling all the times onto
a weekly schedule where each individual's hours for the week are added up.

I have a workbook that many people share. I have a need to place the
name of the person who is making entries in worksheets. How do I put
login name (and time, date of entries) in a  cell in a worksheet?