NEED MORE INFO, DAVE OR IVAN!!!
Posted by Gina H. on March 12, 2001 2:59 PM
I appreciate your quick response, but I can't get them to work. I must be doing something wrong, but I spent most of today trying to add and delete to have the results I need. I am most likely not making myself clear...but what I need is for the macro is actually print the cell references in an equation-like, with parentheses around both and a + sign in the middle. Please show me what I am doing wrong, with instructions. MUCH APPRECIATION!
In Reply to: Re: Is it possible for macro to pause for cell reference? posted by Dave Hawley on March 11, 2001 at 21:36:33:
will not actually be summing anything.
I think Dave meant to have the On Error Resume next
BEFORE setting the Range variable to the
Dim MyRange As Range
On Error Resume Next
Set MyRange = Application.InputBox _
(Prompt:="Select any range", Title:="DEMO", Type:=8)
If MyRange Is Nothing Then Exit Sub