I am using a propritary software that can use script to invoke excel
operations. Is there a list of the commands that excel will accept. Basically
this software creates a report and until now the user would copy as a meta
and paste into excel. I need to

I want users to be able to see only columns A to I. The following
code works in the worksheet_selectionchange() but I don't want it
to execute everytime users make a change on the sheet. If I put
the code in a module, no column is visible. The sheet is

Hi John,
You helped me solve a problem recently with combining values in Excel.
I was wondering if you would mind helping me out again. I have tried to
do it myself but I just can't get it to work the way I would l like.

I have two ranges, range1 is cells C5:C10, I then get the user to enter a
column letter, and what I need is for some code to select range based on the
column letter and the first and last rows selected in range1.
For example, if the users enters 'A' then range2 would be A5:A10, I ...

I am having a user input some info.  The info gets tested, another
hidden form gets the data applied to the proper cells and then printed.
Q1  How can I print the correctly filled sheet without making it
visible?

i need to limit the available selections in a drop down list based on data in
adjacent cells.
ex: if LEFT(A1,1)="D" and LEFT(B2,1)="D" then the list contains options a, b
& c.

I need to name a cell, using a fixed column, column C & a variable row #:
The last row $ of column C (containing values), which changes everyday:
Today the last row # of column C containing values= #24. Tomorrow it'll be
#25...

I have a directory listing for all the files in a particular drive.
With excel macros, I have extracted filenames with extension in column
E. like filename.xxx
i need to extract the extensions in Column F. Now, column E does not

I am trying to set a listbox RowSource to a range of cells on another,
in-active sheet. Is this possible?
Using this give me the range of the active sheet :
   lstAddress.RowSource = "A4:E4"

I have an Excel 2000 workbook which I password protected the vba code. Some
people are telling me when they open my workbook and try and use it by
clicking on the command buttons I programmed, they are prompted for a
password. Normally, the workbook should open and ask them if ...

Hello, through code I have made Excel print a particular worksheet (defined
range)
Is there any way that I can make the windows printer dialogue box appear.
(I would like to select which printer it prints to each time)

When I create Chart objects from VBA, I'm using (X,Y) coordinates to place them.
But after they're all created/placed and the dust has settled, if the user
re-sizes a column any charts that are laying over that column get their widths
changed by the amount of the column width change ...

I need help with the following code.  The following code works except that if
the cell already has a valid value and the user types in a new valid value it
reverts back to the original value that was in the cell.  It only accepts the
new valid value if the cell is blank or if the ...

My Lotus function:
@DSUM($LSTDETAIL,"MTG",@LEFT(ACCOUNT,3)="QEA"#AND##NOT#ACCOUNT="QEAX")
My failed Excel function
=SUMIF(LSTDETAIL,"MTG",LEFT(ACCOUNT,3)="QEA"#AND##NOT#ACCOUNT="QEAX")

I have set up a program to keep track of Registrations fo a Lions
Convention using a Userform to collect the data (LName; 1stname; etc).
Everything works well and I can perform all functions required.  The
Data will fill approx 1500 - 1600 lines starting from Row A1 to the end