Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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))" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
comparing two columns revisited | Excel Worksheet Functions | |||
14 Day Average REVISITED | Excel Discussion (Misc queries) | |||
Help with averages revisited | Excel Worksheet Functions | |||
array revisited | Excel Programming | |||
Last row, last column revisited | Excel Programming |