Very new at this
I figured out how to change the colors of the grid lines on the data
entering sheet, but would also
like to change the color(s) along the edges.

I seem to remember a technique where I could assign a variable name to
the contents of a cell so that whenever I wanted to use the contents,
all I had to do was call up the variable name.  Unfortunately I cannot
find the way to set up the process.  Any suggestsions or ideas would be

PLEASE!  -  Can someone please tell me how to make an automatic
opdated invoice number in Excel
In other words I want to get a new number each time I open Excel
I thank you on beforehand

Is there a way I can format my numbers so when I enter 12345 they will show
as 123.45 without me having to enter the decimal?

Do NOT reply>click the find button>browse to all (msnews.microsoft.com)>from
aaron>move to deleted items

I waste a lot of paper trying to print an Excel 2000 sheet on a piece of paper.
I don't mind multiple vertical pages, but I can't stand multiple horizontal
pages.
Is there any trick I can use to find out if my document can fit so I don't waste

I am trying to create a dropdown menu in some cells in a column of a
worksheet. What I envision is the end user will click the arrow for the drop
down menu and see a 3 digit code with a description following the 3 digits.
I have 2 columns that contain this info where the first ...

I need your kind guidance on how to create a new microsoft words document
using an existing excel spreadsheet? At present, I have an excel spreadsheet,
say "data.xls" containing data for example 6 fields such as COMPANY NAME,
DATE, ITEM1, ITEM2, ITEM,3 & QUOTATION TOTAL. Under ...

I have a macro that manipulates excel data copy-pasted from several Excel
2000 documents. Is there a way to make sure that Selection.Copy copies just
cell values ignoring all other cell properties (formulas, formatting,...)?

Hello Good Samaritans,
 I have a spreadsheet which has a list of documents in it. Some are
classified as "Draft" and some are "Final". The classification is always
stored in Column B. I want to extract the number of  "Draft" and "Final"

Hi I would like to get 3 lots of y axis marked on my
chart one up the middle and one up the right hand side.
Can someone tell me how to edit the chart to let me have
2 and 3 and 4 lots of values

I understand it is difficult to protect vba code. What Im looking for is all
possible methods that could be used to make it very difficult to access the
VBA code. I plan on releasing a template as trialware and plan on using
various protection. I am intrested in any methods that ...

Newbie question:  I am trying to call a module within the current workbook but the following code is incorrect.  I need to use activeworkbook.name becuase the file can be saved as a differenct filename and I don't want the macro to not run because the filename can't be found.  I ...

Hi everyone,
1)I would like to know why after a certain number of rows excel doe
not seem to sort properly.
EX. I have a database of telephone numbers and address and dat

I am trying to summarize row data by a field.  I sub-total then I
collapse the the outline to get my summary.  But then I want to copy
this summary to a new worksheet without the supporting details.  When I
Paste Special it Excel still includes the data that was sub-totaled.