View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default 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