I have a macro that took about 3 minutes to run in Windows XP running Office
2003.  I currently got a much much faster computer and it has Vista OS on it.
I installed Office 2007 and the same macro took over 15 minutes to run.  I
thought that maybe it was an issue with Excel ...

Hi-This code works when in This Workbook section for code but I want
to have it work in one worksheet only. I tried just copying the code
the the specifc worksheet.  Didn't work.  What do I change?
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As

I am trying to copy the first character of a cell and combine it with another
row and place it in another row. I am trying to create usernames from two
columns First Name and Last Name.  I am trying to use Concatenation is this
possible.  How do I do this?

I have a selection range that is non-contiguous and want to load them into
an array. It only load the first range.
set rng = range("A1:C2,A9:C10,A15:C18")
myArray = rng.value

I have a form that has 12 identical lines (same label, button, field
etc.).
In normal VB, I can create each control as an array, ex.
frmMyForm.lblMyLabel(1).

Trying to use a find dialog to do a generic screen scrape, but when I try to
pass beta as a string, I get an error "invalid procedure or call".  I also
tried "" & beta and a few other configurations.  How can I accomplish this?  
Thank you.

This is a real newbie question and there have been a few posts with
code but they don't work for me.
I need to look for columns that have the following in its cell: "c:/
bitmaps/exclaim.gif"

Quesiton:  I have several buttons on my worksheet.  One such button is the
'print preview' option, which print previews the active sheet.  WHen i run
the print preview then close the preview sheet, my buttons are either missing
or stretched all out of shape.

I have been aske to make a spreadsheet that will build a set of formulas
based on the number of sheets being used. The sheets are name shA, shB etc
and can change. The formaula that I need is on a summary sheet and is as
follows:

Hello, I'm trying to copy data from one file to another. The data is copied
almost "as is" except the columns are essentially rearranged. I'm doing it
using the following code (as opposed to copying & pasting whole columns one
at a time) because I want to be able to skip some ...

I am trying to create a macro that when run will open a particular folder,
let you select the text file, than import it.  I have gotten the marco done
that opens the folder, however once I choose the file I am not sure how to
proceed. Right now I do it manually, when I import it ...

Is there a way to set macro security to 'low' for a specific workbook? I have
a workbook with macros that I use all the time & I would like to turn off the
pesky, 'Disable macros', 'Enable macros,' etc. dialog box for this trusted
program, but I don't necessarily want to throw ...

2003/2007
There is a probable a better way.  The GoToWb  opens at the '******* line of code.  If the file
has not opened by '$$$$$$$$$ line then I have the code line -> If Err.Number > 0 Then
       Workbooks(GoToWb).Activate         If Err.Number > 0 Then

I have a macro that I have used previously in Excel 2003.  In that macro, I
use the function complex().  When I go to run the macro in Excel 2007, it
gives me an error and wants worksheetfunction.complex() instead of just
complex().  Is there a way to fix this?  I don't want to ...

I have a problem
This is not working: ws.Cells(3, 2).Formula = "=SUMIF(B2:B7,B19,D2:D7)"
But this is working:  ws.Cells(3, 2).Formula = "SUMIF(B2:B7,B19,D2:D7)"
The only difference is the "=" sign.