Write SUMIF formula to cell with variables

[jaslake]

Hi

I struggle with syntax and punctuation in writing a formula to a cell using variables.

I have this code

Please Login or Register  to view this content.

Where
Dim LastRow As Long
Dim ColLetter As String
ColLetter returns E
LastRow returns 38
and LastRow -2 would be 36

This is the result I'm looking for

Please Login or Register  to view this content.

I get run time error 1004 "Application defined or Object defined error". I've been wrestling with this for the last 4 hours and can't seem to get the syntax correct. Your help in showing me where I'm going wrong will be greatly appreciated.

John

[rylo]

Hi

Try this.

Please Login or Register  to view this content.

You may not be able to split the command line. I can't find the help reference at the moment, but have it mind that there are some string commands you can't split.

rylo

[Paul]

You can split the strings as long as you're between two strings or between a string and a variable, e.g.

Please Login or Register  to view this content.

I think the problem here was that there was an extra ":" in the first bit ("$B6:$B:") and a few unnecessary quotation marks.

[jaslake]

Hi rylo and Paul

I also had an extra colon; I was looking at this issue for so long, I totally missed it. As always, thanks for the help . The code worked perfectly.

John