Posted to microsoft.public.excel.programming

excelent

external usenet poster

Posts: 695

Copy a range with application.inputbox

thanks both for reply

Gary had what i need

"Gary''s Student" skrev:

Sub xCopy()

Set x = Application.InputBox(prompt:="Select a cell", Type:=8)
Set y = Application.InputBox(prompt:="Select a cell", Type:=8)

y.Formula = x.Formula

End Sub

answer the inputboxes via mouse clicks.

Your method
Range(y.address)
hides the parent, so excel does not know which sheet you are referring to
--
Gary''s Student - gsnu200713

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Application.InputBox	Steven	Excel Programming	2	December 23rd 06 11:56 PM
application.inputbox	Christmas May[_2_]	Excel Programming	5	November 22nd 06 04:11 PM
Inputbox and Application.InputBox	Maria[_7_]	Excel Programming	1	September 20th 04 11:36 AM
inputbox and application.run macro1	Michael Joe	Excel Programming	3	August 13th 04 09:34 PM
application.inputbox	Murat	Excel Programming	4	February 24th 04 11:38 AM

All times are GMT +1. The time now is 04:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us