Input box Type:= 8 not working
Thanks in advance for any help on this.
I had built code to define a range
Set rnge = Application.InputBox("Select Cell", Type:=8)
and either one of 2 things would occur
1. Unable to select cell on worksheet
2. rnge not defined ("empty")
This was working in Excel 2000 when I copied a single (row) range and went
to select a cell to paste into. Than it started acting up when I copied
more than 2 rows, and selected a single (from the Input Box) cell to paste
to.
Has my Excel been corrupted or am I missing something...
Thanks...
--
steveB
Remove "AYN" from email to respond
|