Hi everyone, I've got a small problem.
I'd like to send my active sheet with a CDO code.
I use
     .AddAttachment ThisWorkbook.ActiveSheet

Seven teams have their productivity statistics logged daily.  The person who
entered the data only entered the date once for the first team, then skipped
seven lines and entered the next date.  I am trying to do a pivot chart/table
for each month's data, and the blank lines in ...

Hello
Is there a way to value a workbook all at once.  
I have a workbook that has 25 workshheets.  Everymonth I update the report
save it as (v1) then value every worksheet one by one.  

I'm on excel 2003 and just recently when I emailed a file to others, they
received it as a .dat file (a four letter extension) and could not open it?
What's up?

I have some cells with Vlookup formula that return #N/A value. How can I
tell it to show blank when it returns #N/A? Thanks

I have a spreadsheet with lots of colunms, nore than I can fit on any
page of paper.  Is it possible to make a multi-line report for each
row?
What to people with more elaborate report formatting needs to if the

Is it possible to create a writable Excel table within another Excel
spreadsheet that has different column widths that the rest of the spreadsheet.
The upper table has different column width requirements that the lower data
elements.

Does VBA code add to a files size?

I have a workbook with 2 sheets, the sheet 2 column A is always the same as
sheet 1 column A.  I can't put a formula in sheet 2 column B because users
have to enter numbers. When sorting is changed in Sheet 1 column A, how can I
have column B of sheet 2 moved with column A of ...

On some lists when you try the ctrl-shift-end shortcut to select the opposite
end of the list, it adds empty cells that you don't want.  How do you change
this perceived end of the list so ctrl-shift-end ends at the bottom of the
data?  I tried deleting rows but that doesn't help ...

I am trying to input a word into one cell I want to auto generate the
contents of another cell based on the first input.
I can use Lookup if the first input is a number but this does not seem to
work if the first input is a work or alfa numeric.

I am looking for a formula that counts how many times a name from a column
list occurs and match it to another column that also has a list from another
worksheet in my workbook and return it to the worksheet with the formula.
e.g.

I am tring to transfer data from one worksheet to another given certain
criteria using a formula.  Below is an example.
Sheet one
          a                             b

I'm working with a large multi-tab file that I have full of functions to
auto-fill and auto-calculate database values, to save me time on having to
fill all that stuff out by hand.  But the recipients of that file get all
sorts of sorting glitches when they try to upload that ...

I need a formula to help return the value of the first not null cell in a
column, I know the formula that returns the same but in the last not null
cell in a column (LOOKUP(99^99,Sheet1!A:A)), but I need the first not the last
Thank you for your help