Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
I have a subroutine that may or may not be presented with an array. If an array has not been presented, then it should take the array from the current worksheet: Sub CreateTAPPIndex(Optional TAPPMatrix As Variant) If IsEmpty(TAPPMatrix) Then Rem This section understands when the matrix is a raw sheet versus a presented array Range("2:2").EntireRow.Delete TAPPMatrix = Range("a1").CurrentRegion.Value End If End Sub But if TAPPMatrix is undefined, it does NOT trigger a TRUE response from IsEmpty. What am I doing wrong? Is there a better way? Thank you W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linest Array vertical answer return | Excel Discussion (Misc queries) | |||
Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
Array formula correct but end up with 0 for answer | Excel Discussion (Misc queries) | |||
Array gives wrong answer | Excel Discussion (Misc queries) | |||
Differentiate between "" and Empty in array elements. | Excel Programming |