Hello everyone.  I have a data sheet that 14,000 rows long.  In column
A is the customer number.  Then I have a "control" sheet, where I have
a list of customer numbers to pull (copy) from the data sheet
(A3:A20). Can VBA scan the data sheet, create a new sheet for all

I have a macro that finds and replaces "-" with text ("REP") in a particular
column (in this example, C).  My worksheet looks like this:
A       B       C
abc    123    abc

HI,
I run this code ,but always error,why? how to change?
Sub Macro1()
Dim filename

I modified a procedure which Phillip was kind enough to send me a short
time ago. It does what it should but I have one problem which I cannot
seem to get round. In column 8 the first 12 cells will always be blank,
  I cannot put anything in them in this situation so need to ...

Hi, I wish to use some data in my excel 2003 that will allow me to see data
for a range of dates.
In this case I have the first column as dates going back a few years, across
the top employees names.

I have a "menu" page in a workbook that contains a table of numeric values 1
to 15 that represent the default sheet tab names in this workbook.  I want
the user to have the option of changing this list of values to a more
meaningful text description, then have the corresponding ...

Excel 2003 Win XP
I have a  large (physically) userform one control of which calls another
(smaller) UF.
Sometimes the smaller form, when called, appears on top of the larger one

I was wondering if there is a way to automate a process that automatically
runs a VB module which updates all spreadsheets in a folder.  I have created
VB code that copies columns on a current worksheet (sheet 1) and transposes
them onto a new worksheet (sheet 2).  I would like ...

Is that possible to have an checkBox and/or ListBox on
the toolbar.... so the code bellow will be run if checkBox is check, and
listBox
pointing to currency...

i am trying to send mail from excel file
Name   mail id                    check   body
John 1  xxxx@xxxx.com      yes    this is to remind you...1
john 2  xxxx@xxxx.com       yes    this is to remind you...2

When calling a macro from a cell in excel, how can I set the format of
that cell to use for instance Date dd.mm.yyyy ? Do I need to supply
location of the cell I want to format (using Range?) ? Would
appreciate any example.

How to expand/collapse the codes in VBA programming window?
is there any plug-in or software to make it?
thanks!

Hi
I know that the Personal.xlsb file is stored in the C:\Users\user
name\Application Data\Microsoft\Excel\XLStart folder of each computer in
Vista/Office 07

I have a PK column defined with.
Identity Specification = Yes
Is Identity = Yes
Identity Increment = 1

Hello I need some help.
I have a sheet and in the cell C4, the start date of a temporary
vendor is entered.  Cell D4 has a formula to work out the date which
the vendor expires (+ 60 days)