Posted to microsoft.public.excel.programming

Lunks

external usenet poster

Posts: 10

InputBox default value?

I'm getting error on the following part of the program:
Range("Z1").Select
ActiveCell.FormulaR1C1 = myStr
Selection.Copy
Range("Z1:Z" & ncl).PasteSpecial

Error: Run-time error '1004':
Application-defined or object-defined error

myStr is exactly as you posted.

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
Default Windows Profile without default Office user info	Karen	Excel Discussion (Misc queries)	0	November 12th 08 04:53 PM
Default ribbon to open by default when opening xls in browser	Hank	Excel Discussion (Misc queries)	0	April 10th 08 10:12 PM
Inputbox and Application.InputBox	Maria[_7_]	Excel Programming	1	September 20th 04 11:36 AM
Application.InputBox with Default:=0 testing False	bluhme	Excel Programming	2	June 24th 04 12:35 PM
Excel VBA - InputBox DEFAULT Value?	BruceAtkinson[_3_]	Excel Programming	3	May 26th 04 08:18 PM

All times are GMT +1. The time now is 08:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us