I have a query and the result in each cell in the row is #####,###,###
however I only want to see ##### in each cell, I tired to custom format the
cells but it doesn’t work.
Any suggestions?

I'm getting an error message in the workbook_sheetchange event when I execute
the first copy command below after Deleting the contents of a merged range.  
When Updating the contents of the same cell this command works.  The
MergeArea seems to be undefined.  I thought the ...

I need to create an IF statement that will;
Search all of row C: C: on worksheet 3 for a number that matches cell Y on
worksheet 1
Then pull the content of cell Z on sheet 3 and display it in a cell

I need to type DLall in a cell.  As soon as I leave the cell it becomes
Dlall.  How can I suppress this behavior?
Thanks,
Rich

I have created a macro that imports a file and makes necessary changes. The
file location and name are embedded in the macro and must be change prior to
running the macro.
How can I present a dialog box that allows the user to select the file to be

Hei!
My problem is following. My macro uses another macro created by other
person. I cannot modify or even see the macro. After compliting that
other macro I get msgbox telling me it is done. Now I want to answer

I want to add a new module(funktion) in a set of existing modules, compiled
together as excel add-in.
The formula is called "PET_GAS_COMPRESS_Cg" and is as follow:
Cg = 1/P -((1/Z)*(deltaZ/deltaP)

VBA code to email 1 worksheet in a workbook -
I would like to code a function that will email one worksheet in a multi
sheet workbook.  I know you can use the SendTo option on the file menu to
send the current sheet to a reciepient as the email body.  However, I would

I'm filling a listbox with descriptions and amounts.  I want the descriptions
to be aligned left and the amounts aligned right. Can this be done in a
listbox?

Is there a function to convert a numeric value to text and if notm,
how is it achieved through a macro?

Hi I have been trying to load folder and sub folders and file, I can first
level folders but having problem trying to get second etc.
If anybody could it would be much appreciated.
Charles

This loads 26 items from a column into myarray1 (thanks to the posts for
that).  
Dim i As Integer    
i = 1

I have a series of Case Statements which will write to a report sheet. I
then want to copy the sheet to a new workbook. I have placed the command
Sheets("Report").Copy in various places, but it does nothing. Any suggestions
as to what I am doing wrong?

hi,
i would like to know how i can supress te following message:
"do you want to replace the contents of the destination cells in Sheet1?"
i have  DisplayAlerts = False in my code, but its not helping.  i am not

I have a model which allows users to select a range of items to print, and it
can be used from a variety of other model sources.
When it is used it displays the list, allows them to select, then has two
buttons - one to process and one to exit.