I have tried Chip Pearson's sorting code but it doesn't work on my
worksheets. I think his code has to have something more than just numbers. I
have the worksheet names formatted as follows...
mylinenum = Range("linenum")

I have the need to take several lengths of pipe and break them up into
several smaller pieces.  The problem is I need to be able to match them
up eliminating as much loss as possible.  For example, I have 5 pieces
of pipe.  They are 40', 27', 32', 15' and 9' long.  I have to cut ...

Hi;
I wanted to load a list of contols from a userform into a blank worksheet
for later printing.  I want to use it as a personal checklist that I haven't
forgotten to fix or change somethings.  I wrote a short procedure.  Now I

In VBA I can do a relative cell reference from the currently selected cell by
using...
R[2]C[-4]
... How do I achive the same thing within a formula?

I have created a spreadsheet that is run entirely from a userform.  I
want the option to print out the userform.  I currently use the
following code to perform this.
Private Declare Function OpenClipboard& Lib "user32" (ByVal hwnd&)

I have a spreadsheet with 1500 entries in one column A.  Each entry consist
of 4 lines of data and a space.  I need to move the 2nd, 3rd and 4th lines to
columns b,c,d. and to delete the space between entries.
example:

Hello again..  I have created and auto_open macro that is schedule to open
and run, but I will need it to close and save next week.  Can someone tell
me what the code for that is??  I think
Sub Auto_Close()

I had an .xls in Excel 95 that used multipage forms.  This .xls and the forms
works fine in XP (Excel 2003) if I use it without any changes.
The moment I make even a single change in the form and use it, it still
works fine till the time I save the .xls and close .xls.  Once I do ...

Is there a good resource that reviews any basic differences between Excel
VBA programming in 2000 vs. 2003?
It'd appear that there are some diifferences that cause some work I've done
in 2003 (1/3 recorded, 1/3 recorded & edited, 1/3 straight entry) to bomb

I am trying to import a text file into a specific worksheet. Since the name
and location of the file changes every month, I am trying to use the
FileDialog method.  After the user has selected the file, I would like to use
OpenText method  to import the file.  In the file, Columns 1 ...

Sorry started this problem in another thread and didn't realize
subject was the same. I have a sheet with a column ("T) that is
conditionally filtered, with this
filter =OR($T8-$S8>25000,$T8/$S8>120%). I want to copy the cells that

I have bunch of cells from different sheets in a datagrid (that datagrid is
attached to Excel workbook thru some addin). If there are 2 cells (like $M$8
from Sheet1 and Sheet2 in that datagrid) - when I click  Sheet1$M$8 - then it
should hightlight sheet1 M8 cell and when I click ...

What could be the possible reasons for a workbook_open event not finding a
user form?
I am running into this situation and just cannot seem to figure out the
reason for such a behaviour.

I would like to know how I could combine cells with variables if possible.
Something similar to the Selection.Value Selection.Value = “B1& “” “”C1”
line in the code below but which operates like  (x,2)&"" ""&(x,3) so I can
get the appropriate cells to add together with a space in ...

Hi! I have a button that i made from the control toolbox. i put code
into it. i can't figure out how to activate it though so that when i
click on it, it runs the code as opposed to selecting the box for
editing/resizing. can anyone help with this simple issue? Thanks,