Posted to microsoft.public.excel.programming

dok112[_72_] dok112[_72_] is offline

external usenet poster

Posts: 1

Using the value in the inputbox again

add

rng1.Offset(0, 4).Value = rng.Offset(0, 4).Value

after

rng1.Value = Dat

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=48236

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
inputbox	brownti via OfficeKB.com	Excel Discussion (Misc queries)	2	February 9th 07 02:37 PM
Value in a inputbox	Alvin Hansen[_2_]	Excel Programming	3	February 22nd 05 08:15 PM
Inputbox and Application.InputBox	Maria[_7_]	Excel Programming	1	September 20th 04 11:36 AM
Inputbox	sadik	Excel Programming	3	February 19th 04 07:14 PM
inputbox	Lawson	Excel Programming	2	October 7th 03 08:58 PM

All times are GMT +1. The time now is 10:16 PM.

About Us

"It's about Microsoft Excel"