VBA for sumifs() with varying last row

[snelson0713]

I thought this would be possible but I get a "Compile Error" when entering the following code:

LastRow = Cells(Rows.Count, "DH").End(xlUp).Row
ActiveCell.Select
ActiveCell.Formula = _
"=SUMIFS($DG$4:$DG$" & LastRow & ",$A$4:$A$" & LastRow & ",""Unidentified*"", _
$DF$4:$DF$" & LastRow & ",""September 2011"")

I am attempting a sumifs() formula that has a varying last row.

Any help would be appreciated.

Thanks.

[tlafferty]

On which line does the code err? You might try:

Please Login or Register  to view this content.

Use that as a replacement for:

Please Login or Register  to view this content.

You will have to modify whichever column your primary data is in if it isn't the A column.

Regards,
Tom

[snelson0713]

The error was coming up on the last row of code. I just removed the break (" _") at the end of the second row so the formula is all on one line and it worked how I expected it to but I don't understand why.

Thanks for the feedback.

[tlafferty]

Using a space followed by a _ is a designated line break in code. If it's not done properly, the following line won't be considered part of the previous line. You probably needed to start the second line with an & and quotes.

[snelson0713]

Perfect, thanks!