I've created a form with a list box that is populated from a named
ranged on a spreadsheet.  I am allowing the users to add/delete/reorder
the values in the listbox.
My problem is when I write the listbox values back to the named range.

I got a lot of named ranges which refer to a specific workbook however
the values.
for example i have a names range with the following value
='[test.xls]Information'!$C$123"

I'm new at using VBA and I'm trying to enhance the input of an excell
sheet on an automated basis, but I run into some following problem.
Checking the input and should be triggert after the user does
datainput, and this on an automated basis. So I was using a

Is it possible to use hidden cells for the source data on a chart.
At present I have several charts set up which work correctly but is I hide
the data it is using the charts turn blank.
regards

I need to copy all formatting from one row, example cells A14:L14 to
A15:L15.
I am writing a macro to add a new entry. It will unprotect the
worksheet then find the last row, then add the new entry in the row. I

Got the following QuickSort from Rd Edwards (posted on Planet Source Code as
well).
I think the has coded and tested in VB6 and says it works fine, but when I
run it in VBA it doesn't sort

I trying to create a formula in Pocket Excel (WM 5.0) that will simply take
a source column of dates in the format "1/1/2006" and put only the month and
year into a new column in the format "1/2006" to be used by a chart.  In the
desktop of Excel I would just use:

'ive got a userform into which the user enters a particular date.
'The code then looks at each cell to see if the date in the cell is
'greater than the date entered by the user. If it is, then the row is
deleted

I would like to thank everyone in advance for their help.  I was abl
to get started on the code below with great assistance. Unfortunately
the source of that assistance is no longer available.  I understan
what is going on, up to a point.  Let me explain:  I have a sheet tha

Hi, I have created some macros using Excel 2003. They work well, that is they
do everything that they were designed to do... copying data from one workbook
to another and arranging data. The problem is that the person I created them
for wants to use them on a PC in China.

I am sure this can be done, its just a case of how!
When I open my file it hides the application so I can work only with
the form, everything is working fine and I have spent ages making it,
only to realise that if other worksheets are open before opening this

How would this Auto_Open Sub be modified to do this:
If macro security is set to “Very High” or “High,” open worksheet named
“Macro Security”
Else, open on worksheet “REP003.”

ok using the following code to bring up print dialogue
   Application.Dialogs(xlDialogPrint).Show arg12:=2
but I have code which I only want to run if the print has been successful.
Obviously they can cancel out of this  dialogue without printing, which I

I have txt file with many lines of text with variable length of data.
The information of interest is literally contained with quotation marks
within a string.
I wish to;

I have some numerical data in a excel worksheet which is downloaded from
another application. By mistake in some of the fields some non numberical
characters(Ex: "?") are entered. I want to eliminate "?" character using VBA.
Please help.