Flaky Input Box

A

Andrei Scudder

When using Application.InputBox method
returning a string I would very much like to have
references of the following format
Sheet1!R1C1:RnCn consistently returned by the box, rather
than R1:RnCn. The former is returned occasionally
when I restart from a break mode but thats about it. Is
there a global variable that can be set, or something of
that sort


Help is Mucho appreciated
Andrei
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Masking the character in input box 1
Dynamic range thru inputbox 3
Multiple inputs from "Input Box" 3
Input box copying the wrong rows 9
Excel loses mind clearing VBA global variables 2
Input box no longer accepts input 2
Input Box 1
Dynamically adding ActiveX controls via VBA kills global VBA heap? 10

Top