I am trying to copy a range from one sheet to another using the
following statement.
I do not get a compile error but a Object Defined Run Error.
I am calling this from the current worksheet with a command button and

How can I have have the results of a second combobox based on the selection
in the first combobox
Ex. if Ford is selelected in the car combobox the model combobox will only
list ford models

Okay, here's the final stretch to the home-run: I have a VBA Module
that has an extremely long SQL query array. Normally this wouldn't be
too much of an issue, but unfortunately, I cannot make any more "line
continuations", and still have more SQL query information to add to

I have a UserForm that I needed to print out on a 5'x8' sheet.
Currently I have (thanks to this forum)
Public Const VK_SNAPSHOT = 44
Public Const VK_LMENU = 164

I had a previous post with a few questions.  Most of them were answered.  
But, I'm still having trouble.
Here's what I have in detail:
In 'Module1'

Is it possible to show a userform when the user selects a cell (enters the
cell), I can use the selectionchange but is there a on cell enter
/selection?
Thanks!

I tried to use XL4 Page.Setup function to speed up setting properties and I
received an error when trying to apply a font and font style to the header or
footer text.  I'm using C# .NET 2.0 to make the call into Excel.  Can someone
tell me what I am doing wrong with the below ...

I have a workbook with all but one worksheet locked.  I want to write a macro
to unlock specific worksheets only, determined by a dropdown box in the only
unlocked sheet.  I'm not how to go about this though.  Anyone have any ideas?
Thanks,

Hi; I created a macro and userforms on an excel spreadsheet. I want to
copy everything (userforms, code, macros) to a new spreadhseet. How
can I do it?

I am wondering if it is possible to have a protect macro that has a hardcoded
password so that a user can run the macro and it will protect with the same
macro every time, but the have an unprotect macro that makes people type the
password in. I currently have an unprotect macro, ...

I have a user who is getting an error when he tries to load a specific
userform.  He is clicking a command button to pop up the form.  I do not get
the error when I run it on my computer.  There are other userforms in the
file that are working fine.  This is not a large form, and ...

I have a problems to calculate a marketing mix. I thought it would be
straightforward to calculate and explain but it proves to be rather
hard. Probably Harlan will rip my head off but I will just give it a
try...

Thanks now here is second part of question: Do I  need it to match as the
range
will be from C6:C14 (apple,banana, pear etc that it needs to match so does
L35:

I have a user interface where people can go to a number of hidden tabs by
clicking on command buttons.
What the code does is unhide the tab and makes it active but at the bottom,
is another button which will hide the tab and take them back to the first

I have a userform that loads files and the user double clicks on file and I
want to be able to load a pdf file, I have tried the shell method and
createObject non of these work can someone help please.
TIA