| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't input anything I type on Excel. What can I do? Nothing p. | Excel Worksheet Functions | |||
| error 13 type mismatch input box | Excel Discussion (Misc queries) | |||
| How to modify the code for different type of input? | Excel Worksheet Functions | |||
| How to modify the code for different type of input? | Excel Discussion (Misc queries) | |||
| Defining input box data type? | Excel Programming | |||
Threaded Mode
