For work, I have a large Excel Database that is 14 columns wide, and
so far, 74577 Records.  So it takes all 65536 Rows of the first Sheet,
and 9043 Rows of the second sheet.  And I am getting about 100 new
records a day.  With a single sheet of data, I can use Pivot Reporting

Hi
I'm always using the french Chevron which looks like this << to open a quote
and >> to close a quote. I need to get this to come automatically instead of
going to Insert, Symbol. I would love to be able to type the normal quotes

I'm in the process of creating a template, however, I'm not sure what my
options are to save the information that I'm collecting via the
form/template.  What I would like to do is to capture the data and save it to
a database.  Can this data be sent via email?  Please inform me ...

I have already make address in my excel worksheet into Network but suddenly
the address become change to c:\ prompt evenly my former address in
Network..example: my original address-->(In My Network Places)
file:///\\Id740dc01\engineering\Drawings\Sales Drawings\... now suddenly

I build a spreadsheet for radio schedules, I make mistakes when I enter
revisions.
Its hard to make a template for these schedules as the number columns and
number of rows varies from month to month. So if I change the position of one

Is it possible to create a macro that will move down a certain number of
cells (for example, 10 cells) and then enter a number? Thanks in advanced.

USING Excel 2000.
I have a text file that when viewed in excel lists the entire row of data in
one cell.  I cannot parse data because each line does not have the same
break.  I want to extract the fields into individual cells.  I will need to

Can not get value from listBox to Variable.
My code: ListBox1 -> RowSource = A:A
UserForm_Activate() -> ListBox1.RowSource = "A1:A" & N  (# of names in
Col,A1)

Usually most programs have a feature where there is a timed backup made of
each file you work on. The back up is saved in the directory or folder the
user chooses.
Tools/options/save seems not to produce the desired results where the

I've got Excel 2002.  Spreadsheet has over 3400 rows and 6 columns. No
merged cells.  All fonts are Arial size 10.  The first 1809 rows are set to
a height of '15.00 (20 pixels)' and the remaining rows are set to '12.75 (17
pixels)'. I've tried selecting all rows and then double ...

i would like to be able to enter text data in cells in column b on 6
different worksheets and then have a seventh worksheet that will display all
of the text data from the six different sheets on it.  So, if i list 40 words
in b5 thru b45(one word per cell) on all six sheets, i ...

My apologies if this has already been addressed, but I could not quite
find the exact answer in the previous topics. I am trying to create a
macro that does the following:
* There is a user-selected range (R1)

How do I enter a formula in a text cell without changing the text?

My apologies if this has already been addressed, but I could not quite
find the exact answer in the previous topics. I am trying to create a
macro that does the following:
* There is a user-selected range (R1)

I have been using the averageif formula in 2007.
According to the help file the "range" or "average_range" can include
arrays, However when I have attempted to set an array for evaluation only the
first column is evaluated in the result. I only discovered this when I