Quote:VB Cells(10, 4).Formula = "=Max(H &""FirstRow""&,H &""LastRow""&)" I get Run-time error '1004':
Cells(10, 4).Formula = "=Max(H &""FirstRow""&,H &""LastRow""&)"
Cells(10, 4).Formula = "=Max(H" & FirstRow & ",H" & LastRow & ")"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)