Help with Consoldate Syntax

[ballz]

I'm trying to consolidate data that has a Time and a Number. The time is sometimes repeated so I would like to just add the numbers with the repeated time and the non-duplicate time vs number table.

I've done this successfully, manually, using the Consolidate window in Excel.

Then I've done it successfully, using excel and the code:

Range("I2").Select
Selection.Consolidate Sources:=("R2C6:R20C7"), Function:=xlSum, TopRow:=False, LeftColumn:=True, CreateLinks:=False

This will create the table in I2.


My Questions:

1) The R2C6:R20C7 length is varied. The top left will always start in R2,C6 but the number if columns it will go down will vary. I tried hardcoding in 9999999 but then it just takes excel forever to do the consolidation. How do I tell it to goto the last column with a number inside it?

2) more generally, why does this use a R C notation? I tried like F2:G10 and it errored out. I thought it was kinda confusing that I had to use R C.

Thanks for any help.

[ballz]

I got It.

I used

LastRow 0 = Range("F" & Rows.Count).End(xlUp).Row
Range("I2").Select
Selection.Consolidate Sources:=("R2C6:R" & lastRow0 & "C7"), Function:=xlSum, TopRow:=False, LeftColumn:=True, CreateLinks:=False