Morning,
I ran a few searches, but am not entirely sure what i should be asking for.
So i apologize if I missed the answer to my question.
I am attempting to develop an Excel worksheet that will ultimately pull the

I am not able to set the criteria in a autofilter to be dynamic (i.e as the
user is selecting it.) in VBA. The code is as below:
Code:
Sub filt2()

I have a macro that opens another file sent by someone I dont know. When the
macro opens that file there is a msgbox pop up telling me that the readonly
mode is recommended unless I need to change something.
I want to say NO to the Msgbox automatically, which means that I need to

I have written a user defined function but when i go to VBE and press
F8 to step thru the code it does not work. I have gone on many
websites but most seem to show you how to create, not after... like
debug. Any help or website referral appreciated. Thks.

Although the original purpose of this macro is better done in
Data/Filter/Unique, I still need to know how to reference that numeric
variable within the macro as I need to write a new one doing something
different, but also using a numeric variable.

I am opening oWB and need to reference a worksheet code name in oWB.   I have
the following:
       Set oRevisionWS = Nothing
       On Error Resume Next

I have a small program which creates a worksheet at runtime to display
the results of its analysis in the active workbook. I wish to use
either the worksheet SelectionChange or BeforeRightClick event to
respond to the user interacting with a specific section of the results

I'm trying to set the conditional formatting on a row, depending upon
the formula below:
="(S35) > (E35+30)"
It doesn't work.

I am trying to search through the elements in an array (each of which
is a range object).
I would like to use something like
set c=worksheets(1).myarray.find(1,lookin:=xlvalues),

I tried to post earlier and received an error. So if this shows up as
a duplicate post, my apologies.
I have a list of records that contains duplicate item numbers in one
column (which is ok in this setup). I would like to filter this list

The following code reformats phone numbers from "(123) 456-7890" to
"123-456-7890". The macro performs this function perfectly, but the issue is
that it overwrites all strings in the list with the first string in the list.
Example: The macro changes the following list from...

I have written the code below and can see no reason for it not to
work, however when I run the code I get an error saying "Object
Required" I don't understand why I am seeing this error, however if i
change cell.entirerow.delete to cell.interior.color=vbBlue then the

I need to write a Macro that will open up several workbooks (not all at
once),  break all links and then save the workbook and then close it back
down.
Can anyone help me?

I have a list in Excel that contains records with duplicate numbers. I
am trying to filter this list via VBA to retrieve only unique records
and place that list on another sheet in the same wb.
I have given the column that contains the duplicate numbers a dynamic

i am having trouble with this code ..   variable sid pulls the company
code from another workbook.  this works perfectly.  but the error
happens when i enter the do while loop.  when i want to place the
getpivotdata formula in the cell.