Hello everyone! I have somewhat of a difficult question that I hope
somebody can answer.
Here's the problem I'm trying to design a vba that can take you to a
web site and verify

In Excel Macros I have taken date format as DD-MMM-YY and assigned to a
variable and same picked up variable for filtering it is not possible to
filter??   Can anybody help me out .....  Please.........

I would like to get from a range the non unique records. Something like
advanced filter do for unique record only.
How can I do that?
Thanks

Hi Again
I have opened a file successfully (user defined and stored as FileToOpen)
and copied it's content into the active worksheet.
However, since it opens a new instance of Excel, I can't work out how to

i do not want to kill the subdirectory or folder. ( It is an IE cache file
and I just want to go in and clean up what is in the cache.)
The folder, I want to leave alone....
Thanks in advance.

Hi All,
Here is a samplke of an article I found on the net: <Excel's Camera object
is the key to traffic-light reporting. This tool has been a standard part of
Excel for many years, but very few Excel users have ever used it. >

I'm hoping this is an easy question.  Each month I run 5 reports that are
saved as excel workbooks.  I have a macro template that combines and analyzes
the data from the 5 reports.  Each time I do this  I copy and paste the macro
template into a new folder and save the current 5 ...

I'm writing a reporting system that takes an array of data with 25 columns,
and has a front end that allows the user to produce reports based on the
required criteria. All is working fine, unless the value to search for
strToFind is in multiple columns (for example, columns 19 ...

I am using a marco to copy two sheet into a workbook from an existing
sheet in same workbook.
I want the user to have the ability to run the marco more than once
which updates the sheet by going to the database, there fore I don't

I need a total (count) broken down by user (name) and month. What formula can
I use to achieve this? SUMIF only allows 1 criterion, whereas I have two
(name and month).
A2 = Count

I want to use the following subroutine as a function which will return array
aC.  How would I declare it?  Also, how would a sub then call the function
and display the results in a message box?  TIA, James
Sub GetCoordsj()

I am trying to set-up a random sports scheduler using Excel and cannot do it.
I need to input "x" number of teams, playing "y" number of weeks, at "z"
number of locations. Any help would be greatly appreciated.

I would like my workbook to prompt the user for the "type" of a "form" to add
to the workbook, and then run a funtion which creates that type of a
worksheet.
In thinking about this, I have a question......

On Worksheet1 I've got 6 sets of ranges (D34:D36, D50:D62, D66:D78, and so on
for a total of 6 ranges) that may contain the string "ACS" somewhere in the
cell.
I want to search these ranges, and copy both cells to the left of the cell

I have tried this a couple of ways and both give error 1004
For iCo l = iLow To iHigh
   ActiveWorkbook.Sheets("Main").Range(Cells(iReadyRow, iCol)).Value = "No"
Next