I'm removing dupes from a list. The following code gives an "object
required" error on the marked line. The variable is declared as a
range object, is set, and is recognized in the commands immediately
above. So why not in this line?

I am using the macros shown below this post to change the fill colors of
some cells.
Sub Pink, Sub Green, etc., transfer the color code to the main macro,
ChangeSceneColour.

I am using the following code which activates when the userform is changed.
Private Sub ListBox2_Change()
Dim NumberOfCategories As Integer
Dim PickCount As Integer

My customer wants an "Unmatched Query" done in Excel.  He doesn't want to
use MS Access to create this.  Is there a Macro or inbuilt Excel function
that would let us do this?
Scenario:

Hi, is it possible to creat this by macro ( please see below)
Message should come up
PLEASE WAIT..
PLEASE WAIT....

Is ther a way to disable all keyborad shortcuts in a "For Each" or similiar

We are working on a spreadsheet and we need an email hyperlink with a subject
line that will reference the content in a cell in our worksheet.  For
example; in the worksheet, we have an invoice number and we want that to be
in our subject line, however the invoice number is ...

Is it possible to go through all the user forms and only load up the one with
the name I want.
So If I had a form called "frmMain" and a ton of others, would it be
possible (before loading the form) to go through these forms and use a string

Every time I try to add a RefEdit control to a Modal form, I get the error
"Invalid Argument".  Does anyone know why and how to avoid this?

Under Temp worksheet, there is 0.03 (2.6%) in cell A1.
I would like to copy anything inside the blanket (), in this case, I would
like to copy 2.6% into cell B1 under Summary worksheet.
Does anyone have any suggestions on how to do it in macro coding?

Hi, In the following, I need to add:
MsgBox "No #N/A cells found. Nothing to copy. Finished."
--and when clicking OK, close the workbook without saving.
before exiting in this statement:  If Not IsError(.Cells(lr, "r")) Then Exit

I want to require the user to enter his/her name in a specific cell (E59)
before the user can save the file.
I tried using Data Validation where I specified Text Length between 1 and
40, and left blank the check-box for "Ignore Blank". Nope.  I never

Is there any formula that I could use to be able to sort the below
information into a format that I could create a pivot table on?
Invoice #:    12345    Invoice Date:    1/16/1950    A/P Code:    ABC
Due Date:    1/16/1950    Total Payable:    $100.00     Reference:    Freight:

I need to use r1c1-style in excel formula.
when I do for example "=r2c3", excel reports an error. How do I use r1c1
style in formula?
thanks,

I have the following statement:
With...
...
...