View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt S Matt S is offline
external usenet poster
 
Posts: 112
Default Min not zero revisited

I am trying to input an array function onto my Excel sheet through VBA. I
try the following code, and instead of giving me some type of error... it
just skips past the rest of my code and goes straight to "End Sub" after
trying to evaluate.

Can someone please tell me two things... 1) what did I do wrong? and 2) why
would it skip all the rest of my code and go straight to End Sub?

Thanks!
Matt

LastRow = Cells(Rows.Count, "F").End(xlUp).Row
ActiveCell.Offset(3, 0).FormulaArray = "=MIN(IF(R13C:R" & LastRow &
"C)0,R13C:R" & LastRow & "C))"