Under, Tools, Options, Error Checking, I can check a box called
"inconsistent formula", but it doesn't seem to pick up much.
I have a formula:
=CostEntry!CD99-SUM(CostEntry!CD115:CD117)

I need to open a series of spreadsheets in a directory, copy a worksheet
from each and paste the worksheet into a new spreadsheet.
All of this I can do, but the spreadsheets I have to open have links to
other spreadsheets that cause the 'Update?' message box to appear.

i have two sheets, one has a list of names and corresponding amounts.
the other sheet contains a second list of names and amounts in the
next two columns. Some of the names are appearing in the first list. i
need to create a macro which will  scan through the two sheets, and if

I have a number of spreadsheets with customized menu bars across the top.  In
each of these, I use Workbook_Open, _Activate, _Deactivate, and _BeforeClose
to ensure that the right custom menus end up on the right worksheets as I
move from on workbook to another.  

Is there any way to , programmatically, disable  the excel built-in keyboard
shortus ?
I'm using .Net but welcome any solution (VBA,...).
Thanks

In Excell 2003 I have several macros that pull data from and access data
base. This is fine except I have to run a macro in access to update that data
base first. Is there a way to run the access macro from within excel with an
excel macro?

need help, trying to use vlookup on a simple table to find sheet/tab name, go
to that tab, drop in some data, and then return to table.  any help greatly
appreciated!

Hi - I'm a newbie with VB programming, so this may be a simple
solution which I'm just missing, but....
I'm using the Calendar Control version 11 within my spreadsheet to
allow a user to select a date for a specific cell. I have set up the

Let's say I have a directory structure like this:
FOLDER1
   FOLDER 1A
         FOLDER 1A1

Can anyone help to modify this code to read/copy specific cell data from the
myfile and send it or assign it to my active workbook? my active workbook
will be my "master" workbook where I'll be gathering all data. The "myfile"
(source files) are not in a columns and rows format, ...

I have a report that generates into Excel and it leaves some crap in
the last few rows that no one needs.  It results in a few extra pages
printing out (unless someone takes the time to manually remove those
rows).

I have a program that renames the names in Column A and its associated
worksheet.
All the names in Column A are hyperlinked to its associated worksheet. The
names in Column A and the worksheet name are the same.

Can someone please give me an advise, how to convert in VBA e.g. this
string "VYé¬TOVµNÖ ¬µSTI SOUD.POPLATKU" which comes from DOS 852
codepage to UTF-8 or to Windows-1250 codepage. I was trying to use
e.g. WideCharToMultiByte but I am not experienced enough to do it. BTW

I'd like to be able to rename my worksheet tabs based on the contents of a
cell within that worksheet (same cell in each worksheet).
Any suggestions?  TIA

I am looking to start learning vba code and I have Excel 2003- I have very
limited programming experience! Can anyone point me in the direction of some
useful courses (preferably online)?
Cheers,