I need the code for selecting a specific range of cells on the same row
as the active cell.  The active cell will be selected with a cell.find
operation, so it will not always be in the same column.  Thus, an
activecell.offset won't work.

Is there anything I can add to this to diplay a progress bar also?
Application.StatusBar = "Processing " & sh.Name
Thanks,
-- Dan

I have a procedure in a user form and I need to have it execute a procedure in a
worksheet module (same workbook).  Basically I need to "Call mySubroutine()"
from a form to an outside subroutine.  How do you do that?  Even a "GoTo xxx"
would be fine.

I have the following code to pick up infomation from the spreadsheet
and show it in my userform.
Dim text1 As Long
text1 = UserForm6.TextBox1.Value

I have an project i'm working on to determine fiscal periods based on
date of invoice. I have one workbook ("FiscalPeriods.xls") that has the
date ranges for each fiscal period for the past three years. ie;
Period    PeriodStartDate    PeriodEndDate

Hi All.........
I have code which puts a 3-level Conditional Format in a cell, U9.  I would
like to copy just that CF down the column U as far as there is data in column
C.  I've tried, but just don't seem to be able to get it right, and recording

Can someone help me translate the following formula?
=VALUE(IF(ISERROR(INDIRECT(U61&$V$61&MATCH($B$60,INDIRECT(U61&"A:A"),0))),0,INDIRECT(U61&$V$61&MATCH($B$60,INDIRECT(U61&"A:A"),0))))
U61 = Belgium!
V61 = h

I'm trying to create a macro in vba that will compare a list of items
in a named cell range to the values in a page field of a pivot table.
The named cell range is a subset of the complete list of values in the
page field of the pivot table. I want to hit a button and the pivot

I'm trying to write a large array to a range on a sheet next to another range
that may have filtered rows.
I'm doing this:
 rng.Cells.set_Value(Type.Missing, (object)arrValues);

On my worksheet (Excel 2003), I am using the following code to format:
  Range("D6:D555").Select
  Selection.NumberFormat = "0.0000"
The problem is every 40 or so cells I have merged 5 rows from A to S.  These

my code writes a changing calculation value to another part of my
spreadsheet.
I am trying to amend my code to paste to another worksheet in the
workbook and also write to a different line each time the value changes

Let's say I have a spreadsheet(questions.xls) that represents a
customer questionaire, formated in a fancy page layout.  I will email
that questionaire to 1000 people.  They will fill it out and email it
back to me.

can anyone help with the vba code for selecting either the GrandTotal Column
or Row in a pivot table.  I seem to be able to select just about anything
else but these.

I wrote some code that has become to large. I get a compile error: procedure
to large when I try to run it(from a button click). I need help re-writing it
so its smaller. Here is the code, this example is for just one employee, i
have to do this for 9 employees in total, that's ...

I have big xls file. I run macro on this file and in the macro I add new
workbook by:
Set NewBook = Workbooks.Add
In the new workbook I add data (between 5 to 100 rows) and the create