I am getting a #N/A error when using the LOOKUP function in conjunction with
LEFT.
I have a number followed by a letter (e.g., 7442C). I want to compare the
number portion (7442) with a range of numbers (E1:E10), and return the

dim xlbook as excel.workbook
dim xlsheet as excel.worksheet
dim xlapp as excel.application
set xlapp = createobject ( " excel.application")

Here what I am trying to do. When I creating the Pivot Table, the table auto
calculating the Grand Total field. What I am looking for the Differences from
one month to another not the grand total. See example.
This is what I have

How to restrict zeros in a number from 16th digit onwards.
In other wards I made cell format as "Number" with no decimals. I entered a
number in that particular cell with 1234567891234567 (16 digit number) after
enter key it converting as 1234567891234560 ( "0" at 16 digit)

I want to write a line into a macro that will print all worksheets in a
workbook, apart from a sheet called "HOME".
Can anyone tell me how to do this?
Thanks

I have a spreadsheet with 5 long columns of information.  I am trying to
print it using 2 "newpaper" columns in portrait format and can't get it.  Can
someone help?
Cheers

Col A contains a list of dates.  In Cell B1 I enter a single date.  How do I
write a macro to find the cell in Col A with the date which matches B1 and
make it the Active Cell.  I could use Edit/Find but do not want to re-enter
the B1 date in 'Find what:'.  I want the macro to ...

Suppose I have a value in A1 and the formula
=FormatCell(A1), calling the following macro, in B1
Function FormatCell(a As Range)
   a.Cells(1, 1).Select

I have a data download that is appearing in the column like this:
1021,105,1268
I am trying to delimit it to appear in 3 seperate columns like this:
1021                  105                         1268

I'm working with an order form and need a formula that converts an "each"
qty. to a case qty. For example - I need 55 each of an item but can only
order in cases of 24 each.
D21=24 (case qty.)

I have a long column of numbers and I need to have these numbers converted
into text, as would appear on a cheque for example. Is there an easy way of
doing this without me having to type the text in individually?
Thank you

dear sir,
is their any code which can create an TABLE / QUERY containing all the days
of the
current year like from 1/1/07 to 31/12/07

I'm using the beow mentioned formula to calculate the NUMBER-OF-WORKING-DAYS
in the month,@5 day work week(Mon-Fri).
=NETWORKDAYS(EOMONTH(D2,-1)+1,EOMONTH(D2,0))
Where 'D2' is '=now()' to calculate current date.

I want to create a row for each document.  I have over 100 documents I want
to link to.  Does anyone know how to create many hyperlinks at one time
rather than just 1 at a time?  I am using Excel 2007.

I am trying to use conditional formatting to make an entire row red if the
content of column B for that row has the word "Exception" in it. I only
succeeded in conditionally formatting that particular cell. How can I get the
formatting to apply to the entire row, when the cell in ...