lastcolumn = Sheet3.Cells(1, Sheet3.Columns.Count).End(xlToLeft).Column
Sheet3.Range("B17:" & lastcolumn & "17").Formula = "=SUMIFS($H:$H,$B:$B,B$1)"
it is not working :(
Asked
Active
Viewed 44 times
-1
-
1What does not working mean please? – QHarr Nov 03 '18 at 15:15
-
1your formula for **lastcolumn** is returning a ***number*** correctly................your range statement needs a ***letter***. – Gary's Student Nov 03 '18 at 15:25
-
I am not sure how to apply the lastcolumn into the range statement – Max Nov 03 '18 at 16:20
-
You can use Cells method and pass a number in as column argument. – QHarr Nov 03 '18 at 16:38
1 Answers
1
As QHar said, use
Sheet3.Range(Sheet3.Cells(17, 2), Sheet3.Cells(17, lastcolumn)). ...
chris neilsen
- 52,446
- 10
- 84
- 123