Can anyone please tell me how to open the built in "Find" command in
Excel, with a macro
Thanks in advanc
Axel

Fellow peeps
I have some CSV files exported from Requisite Pro.
When I just open them from Windows, they come in fine.
When I try to import them through VBA, the formatting is different and

I am using Office 2003.  I know how to write a formula in a new cell and set
it equal to a different cell's date plus 100 years.  I can then copy new
formula and paste special to original cell.  But I sure can't figure out how
to do this with a macro.  I am thinking I declare a ...

If A1 = 5
How can I display a Date/Time [A1] minutes earlier than Now()
Chuck

Let's say you have a phone number in a cell with the following format:  
(555) 555-1212 Ext. 0000
How do you make that to be 55555512120000?
Thanks!  

I have a worksheet that when the user checks a certain checkbox certain rows
and checkboxes are hidden.  This sheet needs to be protected, but when I
protect the sheet and click on the checkbox I get an error in the code that
hides the rows.  Works fine when the sheet is not ...

greetings!  i've got a macro which requires user input in the form of a
userform, consisting of combo box, and "OK" and "cancel" buttons, then takes
the selected info and continues to run code.  
my question is: when the cancel button on the userform is chosen what code

I am trying to Do a spread Macro for budgeting. I want to specify a column
when a number is entered and I hit the Macro button that number would be
spread in the same row in 12 (months) columns

I have a mixture of old and new systems.  I need to automatically save a .dif
file as an .xls.  Is there a way to automatically say.. run a macro to open
the file in Excel then save it?  This of coarse would have to be done without
user intervention.  A batch file or scheduled ...

I have a worksheet where column 7 & 8 are populated by the user selecting an
item from a drop down box.  Both columns have code allowing the user to
select multiple items from the drop down box.
Is there anyway (ontop of the current coding) to only show certain items in

I would like to know if I there is a way to count the number of times a value
in a cell changes.  I have a spreadsheet that reads in data from a "PLC" and
the data changes throughout the day, what I am looking for is a way to count
the times that "value" in the cell changed.  ...

Hello Excel Group,
I have a question (Excel 2003 and VBA).  I have a worksheet with a
column of dates,times, and values.
the first col has a date (13-Sept-2007), the second col has a time

How can one create a Histogram, given the data in an array, and other
parameters (Binsize, Max and Min), without using the frequency funtion
of Excel?
Any help would be appreciated.

Why does this not work:
Sub TEST()
   Dim TESTVAR As Integer
   Sheets("DataQuery").Select

I am running macros in a spreadsheet as part of a questionairre.  As one of
my questions pops up, I type in a client name or I click on the tabs at the
bottom and select a cell that should populate information in my spreadsheet.  
Now it is erroring out and will not let me ...