I have some code assigned to a button that copies data from one work
sheet to the first blank cells in certain columns in a second
worksheet.
What I now want to do is fill the remainder of this "new" row with the

There is supposed to be a help file for use with the Spreadsheet ActiveX
Control called: MSOWCVBA.chm.
Can anyone provide a web link to this file so I can download it?
BTW, I am on a network, and I don't have access to the install disk, that's

I have some VBA code in which I changing dates from Euro style to U.S.

quit but it still hangs around.  Any clues?
Option Explicit

I have a winform application which is addin to Excel (written in C#). Is
there a way to dock this form in Excel - I want to dock it to  right most of
the Excel workbook. Thanks for any suggestions..
Thanks!!

I have two versions of  a file, one current, and the other in template form
in a different folder.
Same filenames, different locations.
When user has one version open, I need to be able to check which version

I can not remember the format and code to keep the screen from updating as
the code executes. "screen.update = false" or something similar, then when
done "screen.update = true".
Thanks you

I printing reports from 4 different files who names change each month
depending on the month and version
I would like to enter the file name in a cell in the worksheet. Then have
the VBA code search and return the path where the file exist

Hello, i have been searching the threads to get some info, but nothing
answered 100% my question. Is there another way to have access to the
variable size than using the call in the following code:
Option Explicit

I've looked at related posts but they do not seem to exactly correspond the
problem I am having.
I have an XY series for which I wish to replace each existing label with a
'custom label' in an alphabetic sequence, e.g., (a), (b), (c) and so on.  The

I am an enthusiastic amateur just starting our at this VBA business.  I
appreciate I may appear ‘slow’ but this issue has be vexed.  How do I
populate a listbox or combobox in a userform from a named range on a
“Reference” worksheet?

On 6/21, CWillis asked about spell checking. NickHK said he should use the
syntax 2 but no explanation of how to do so. I have a situation where I have
a column of data, one word per cell, that I would like to do a spell check
on. If the word is good, save it to a different cell ...

I have a file with 5 pivot table
Each time I want to filter, I have to go on each pivot table to do the same
filter
How can I automize this ?

I want to automate the "text to column" function.  I can created the macro;
however, when I rerun the macro on a new row/cell, it writes back to the
previous row/cell and overwrites what is there.
I need the macro to run in the new row/cell where my cursor is, and then not

I have been spending a lot of time trying to figure out dynamic chart
ranges and just can't figure it out.  I have a chart (scatter plot)
that needs to have the X and Y values of a series linked to the number
of values present, which will be constantly changing.  It would also be

I am planning to protect my workbook from being copied over without
purchasing license to be used from one franchise into another.
is it possible to create a script into a workbook that sends a message
(containing information about either info about user of the workbook or