Excel 2003
I have a spreadsheet that has groupings
           col a        b            c            d
row 1     2                                     sum(r2:r5)

I an using your copy next each other sub and last row function.
My question is there a maximum number of ranges that can be used within the
Set sourceRange = Sheets("Sheet1").Range statement. I have 41 ranges which
works fine but as soon as i add further ranges i get a run time ...

I posted the below on the excel worksheet function forum and was advised to
post here: please see two queries below.
Thanks.
1)

I am trying to paste an Excel range selection into an MS Outlook Task body
using code. This can be done manually with a Copy of the range selection and
then a Paste Special into the Task body as a Microsoft Office Excel
Worksheet. The Paste Special allows me to keep the Excel ...

I am using Excel 2007, and have previously written, and used. several
macro's on this machine.  Recently, however, the 'Visual Basic', 'Record
Macro' etc icons have been grayed out, and I am unable to access the
"programmin" portion of Excel.

Hi.  I have a situation which requires the vba coding of excel to move data
from an excel 2003 worksheet to sql server 2005.  I am somewhat familiar with
vba but not in moving it like this.  Also, as the data updates on the
worksheet, the vba needs to fire at set times (ex: every ...

I've read most or all of the threads relating to e-mailing worksheets or
range selections, but I do not see how to copy a range selection from a
worksheet into an Outlook task body. I would like to keep the Excel format.
This is manually accomplished by a selection Copy then a ...

I am using Ron de Bruin's code to copy "usedcells" to a excel
database/masterfile.
This is what I got so far:
Sub copy_to_another_workbook()

First, sorry about the double post, but realized I posted my question to the
wrong forum.
Can anyone tell me why this code not only pastes the Formulas (which I want)
but also the values in the cells?

Simple one - I think!
My main application (Excel Workbook) opens another workbook with named
range(single cell). How can I refer to these named ranges and return the
value.

I had a friend that used to do this and damn it if I can find that
file.  Anyway, does anyone know how to condense a spreadsheet using a
macro that can select and hide only the rows that are empty.

I have created a structured spreadsheet (not filterable) for reporting of
various sales by industry.  I have also added macros which displays only rows
related to specific industry groups.  To ensure the totals sum only the
visible cells I have added the attached function code to ...

Hi, friends. Please look this:
I know there is an article answered this question at
http://support.microsoft.com/kb/q294782/. But I still want to know how to
extract aggregate value in a cell when columnmember is null.

I have this line in my UDF which worked in excel 2003 and I seem to be having
trouble in excel 2007...
If eigth = 3 Then
       TYfrac = root & "-" & fracint & "" & ChrW(&H215C)

Is it possible to check all the time if a sheet has by mistake been switched
to manual calc?
I have tried the below but obviously not working as when we are in Manual
calc no calc is done to triger the volatility of the function.