I am using the following macro to copy the last four rows of information.  
Here is the problem.  The information starts in column "B" and I need to copy
it to cells("B9") Not cells("A9").  If I change cells("A9") to cells("B9") I
get an error, "area size doesn't match" or ...

Below is an adaptation of code that was provided by Dave Peterson as a way to
automatically change sheet tab names based upon manual entries made on a
"Menu" tab.  The code executes perfectly---that is not the issue.  The
problem is that after you type the description (in any ...

Hi.  I am trying to sort a block of data, and when I do I get really
bizarre results!!  It is not sorted at all, and the block of data that
is highlighted AFTER the sort is smaller than the block of data I
highlighted before the sort!!  Can I send someone the worksheet to see

I have a list of data that gets filled out every week something like
Data1
Data2
Data3

Please HELP!
When I first call the code below in a macro from another spreadsheet, the
execution halts at the ‘SelectedSheets.PrintOut’ line.  I have to close down
EXCEL using the Windows task manager.  After I clear all instances of EXCEL

I have an application that makes use of excel Interop
I’m using Microsoft Excel Object Library 10
The application does the following:
•    Loads an existing analysis spreadsheet

I am using the following code to extract numbers from a string
http://www.ozgrid.com/VBA/ExtractNum.htm
however when I have strings like WS123ABC45cft, I would like to extract only
the first set of number"123". The code provided extracts "12345"

(XL2003) I'm trying to get this to adjust so it fills a landscape page
left margin to right margin.  I do't care how many pages the rows
cover.  Right now, the rows cover three pages.
The first time, the page formatted with A:L for three pages, then M:P

I have a weekly status sheet I re-create each week. I'm writing code
to do it. So far, it creates the new sheet and copies the formatting
from the first 3 cells of the old sheet into the new one. They all use
conditional formatting. What I want to do next is open the conditional

I try to use this qurey
szSQL = "SELECT * FROM [Blad1$] WHERE A = 1"
and it works fine if I don't use "WHERE A = 1"
Another question is how to do if I want to do somthing like this

Here's my situation: I get a packing list in an excel spreadsheet that ties
directly back to one or more purchase order(s).  
The spreadsheet has 4 columns from L to R: PO#, line #, Item #, quantity
shipped

I am trying to fix a problem with a workbook and macros within the workbook.  
Here is the issue:
I open a workbook that contains macros in another workbook.  The files are
located on a server under a mapped drive in windows.  The workbook is a .xls

I know I asked this before, however I don't think I was making myself clear.  
What I have is a chart that has 2 columns on it.  What I would like to do is
keep one column and make the other a stacked column.  I know I can do
combination charts using a line and column, however I ...

I am not grasping some things about programming to the Quick Access Toolbar
(QAT).
I am trying to get a macro to show for any workbook that I open as long as
it is opened from a specfic folder.

I have a 10+ year old add-in (still using Excel4v) that is fairly
complex.
Everything seems to work fine in Excel2007 except for a piece of logic
that