i am having trouble with this code.  I am trying to pull data from a
pivot table i created in my personal.xlsb workbook..
Variable "sid" pulls the company code from another workbook.  this
works perfectly.  but the error happens when i enter the do while

Oh, nutz <g>! The problems of being adept in one programming language, and
then jumping into another. I have a nice little book called VB & VBA in a
nutshell. I need to find something on one worksheet based on a search
criterion from another.

I've got a control file which produces team workbooks - one sheet per member
of staff.  It then adds in a manager template.
All this works.
The final step is to call a procedure, "PrepTheTemplate" which customises

I would like a script for detection of ”outliers” during data anaylsis and
removal as a second step.
I have a range of cells containing ”control” values and specific cells
containing the ”outlier” limit values (high/low, e.g. +/- 2 SD from average).

Could anyone suggest why the following doesnt work. Im using it behind
a worksheet to copy down formula but when I ammended it to include
copying from A85 to column A it stopped working. It also appears not
to copy formatting which I would like it to do. Could anyone make any

I am serching for a string but the string seems to have an invisible control
character - probably Chr(13) or something of the like at the end. My script
is :
Range("A2").Select 'Set for start range

I have the two pieces of code below in my spreadsheet.  When I run the
Engineering macro I get  a run time error 1004 with the message "Unable to
set the Hidden Property of the range Class for the following line.  
Range("Long_Lease").EntireRow.Hidden = False

Sub CreateMenuItem()
   Dim ToolsMenu As CommandBarPopup
   Dim NewMenuItem As CommandBarButton
   Call DeleteMenuItem

I need help in converting date which is in dd/mm/yyyy to mm/dd/yyyy
format.
I need to write a macro that will convert column B which holds the
date to

Is there a way to enter dates American style (e.g. 4/25/2007 rather than the
English 25/4/2007) into Excel and be understood without changing my regional
settings?

actually it's a repost, trying to improve last message title ...
When performing a SELECT how do I tell my tables are located in different
paths?
I'm doing:

I have some 15 charts in a spreadsheet along with some data. I want to
reposition the charts in 3 rows and 5 col. I achieved this but the
issue, position of the charts get exchanged once i run the macro.
For example, after "Chart 4" is repositioned, macro selects

Can GetOpenFilename be used to display a dialog box which is filtered
by specific files names, i.e. a filter applied to the file name as
well as the file type?
I know I would only get one file at most per directory, but it would

I am trying to write a macro that will search through a list of values (this
list will vary in size) for all values greater than or equal to a specific
value (say >=100). I want to activate all the cells containing those values
and copy them to another location. Can anyone help ...

I AM TRYING TO CREATE A CUSTOMISED TOOLBARS HOLDING SOME CONTROL X COMMAND
BUTTONS.  EG OF HOW THE BUTTON WORKS AS FOLLOWS :
WHEN I CLICK ON THE BUTTON AND HOLD ON TO THE BUTTON, IT WILL CONTINUOUSLY
MOVE THE SELECTED OBJECT SAY A DRAWN RECTANGLE ON A WORKSHEET TO THE LEFT AND