I am trying to populate an array from an user defined range via an inputbox, but am having a little trouble.
Basically been using the below... trying to force into an array, but I think there is some type mismatch somewhere.
Set LastRange() = Application.InputBox(Prompt:="Prompt", _
Title:="Range Finder", Type:=8)
Any idea on how I can assign that range to an array. Thanks guys!!
Basically been using the below... trying to force into an array, but I think there is some type mismatch somewhere.
Set LastRange() = Application.InputBox(Prompt:="Prompt", _
Title:="Range Finder", Type:=8)
Any idea on how I can assign that range to an array. Thanks guys!!