I have a worksheet that has names of managers.  I need to open a new
worksheet that can merge all the info on one specific manager from any cells/
other worksheets.
this is what I have on the columns

Below code compares and gives the result in numbers.What I want is
instead it gives number like 2 or 3 it should gives the names.So how
can I print the contents of the cells after it does sum.
Thanks for your help

Please forgive my novice approach to this problem, I am a newbie to macros.
I've done simple ones but this one I am scratching my head too much.
This is the data I work with:
Code    Product    Line    Batches    Start    Finish    Day

This is called from vbyesno
ActiveWorkbook.SaveAs Filename:="A:\LoadingSupplies.xls", FileFormat _

Useing this from a userform click event trying to have user chose location

According to this information
http://msdn.microsoft.com/en-us/library/bb213289.aspx
The PivotCache.Recordset property should be able to return a Recordset
object.  When I attempt to set rs = PivotCache.Recordset I get a '1004'

I have written a macro (which is in a module) and I have signed it with a
VeriSign digital signature/trusted certificate.  There are NO macros behind
any of the worksheets or in the "ThisWorkbook" module.
Every time a right click on a sheet to make a copy...it breaks the digital

I have an Excel form file with 10 fields that I send to different
customers to complete. I can't link the cells because I am sending
them to outside companies.I would like to have a log that summerizes
all of my received files.

I have a VBA form in excel that allows users to select which field in a
Pivot Table to display.  The selection that the user makes is a field called
'Select_Report'.
My code (below) then allows the Pivot Table to filter on a Pivotfield called

I am trying to call a function in an installed XLL addin in excel. Unless I
declare the function, I cannot use it.
If I use this declaration:
Declare Function EssVDisconnect Lib "ESSEXCLN.XLL" (ByVal SheetName As

I need help adapting VBA code that I found on Contextures.com
When the end user chooses the two page fields in ptMain, I need it to
automatically enter it in pt2, pt3 and pt4. pt2 is on the same page as
ptMain. All four pivot tables use the same page filter.

I need to somehow change the below code so that it only prints data
that is visible after it's filtered on the data sheet. Is this
possible?
Public Const APPNAME As String = "Elephants R Us"

Please Help needed
I sort of figured out how to color the background of the cells but I
am totally lost as to how to put this all together to get the results
I must have to get my sheets done.

An application, that I originally wrote in Excel 2003 VBA, creates an Axis object (xlValue) and then sets the ScaleType property = xlLinear.  When I run the application in Excel 2007, though, I get an error:
Run-time error '-2147467259 (80004005)';
Method 'ScaleType' of object ...

I'm new to programming in Excel and I have a specific project I could use
some advise on.
I have a need to be able to copy specific columns (qty. 3 - 10) from
specific worksheets (qty. 5) from one workbook to another.

Is is possible to hide the bar in open wookbook and then restore it with
before close event?
I am not 100% great at VBA, but i have some basic Knowledge.