Hello to all,
I have a range of cells C34:N35
I need VBA code in order to have borders for this range or clearing the
borders depending on the checkbox if it is cliked or not.

I seem to remember there was a feature in Excel for a data entry popup form.
I have a simple table of records with about 8 columns and I would like to
have a form to take the data entry.
I am in Excel 2007

Does anyone knows how can apply the countif() function partial? (for ex. If
i have the column A10:A100 to apply countif() in the follow cells A54,  A67,  
A72:A79 , A87,  A91:A95,  A98.)
If that impossible, any other idea?

I have Excel 2003 at work and I want to save a file it in a flash drive or
cd and work on it at home using Excel 2007 then later update the file at my
work (Excel 2003).  Is this possible? or if I save it in Excel 2007 I can't
go back to Excel 2003.  Any tips will be appreciated. ...

I have a workbook that has too many tabed worksheets.
Is there any way to easily set up a "first worksheet" Table of Tabs
(contents) worksheet, so that when I select a tab from the Table of Tabs, it
will take me right to the  worksheet?

Does someone have a macro or script to append a bunch of xls files in
a directory into 1 xls file?  I am using Excell 2007.  Thanks!

Thanks for Dave Peterson help I was able to to create a macro that will
clear the numbers only on the sheet, but not the formulas, below is a sample
of my code. Here is my problem I was able to clear the cells in the column -
numbers only not formulas, lets say column D, ...

I'm attempting to tutor a blind student.
Is it possible to reselect a chart using only the keyboard.
TIA!  Bill

Here's what I have:
A spreadsheet sent to me with a list of filter part numbers, with each
vehicle having it's own row and each type of filter (air, oil, etc) having
it's own column. I would like to create from this data a sorted list of each

We are running Exchange 2000 / Outlook 2003. After staff realignment, we
have an assistant who no longer reports to a manager. The manager has
removed the assistant from her calendar shared list.  Now when the manager
sends a meeting request to various attendees, the assistant is ...

I need to track the usage of several hundred items.  They can be
lumped into three or four basic categories.  Each one has a unique
identifier.  I need to track when an item came into the system, when
it was replaced, and the item "life"  - this is done by date and by

I was wondering if there's a way to archive a whole row in excel. For
example, if a cell in the row is selected as 'complete' can excel
automatically remove that row and archive it elsewhere?
Thanks in advance.

I accidentally deleted all data from an excel sheet and closed it.  Is there
anyway I can retrieve this document? Please help ASAP. Thanks. G

Hi, I tried to do a data exchange between worksheets, should I use "Macro" or
"VB"?
To explain it in a a little detail, I got some experimental data ouput and
saved on one worksheet (named as "Cent1" under "workbook1"). I want to export

I made an Excel 2007 workbook which includes my monthly business income,
parts bought, a logbook for car mileage dividing into personal and work and
finally a financial end of year total constantly updated by the income or
parts bought over the financial year.