application/object defined error

Posted to microsoft.public.excel.programming

rudekid[_2_] rudekid[_2_] is offline

external usenet poster

Posts: 1

application/object defined error

sorry, figured it out: Cells syntax was wrong! eek:

For the record, the correct code now reads:

Dim Cell As Variant

For Each Cell In WhtCode.Range("N2:N30")
If Cell.Value < "0" Then
whtData.Range(Cell.Value).Cut
whtData.Range(whtData.Cells(Cell.row, 26)
whtData.Cells(Cell.row, 26)).Select
ActiveSheet.Paste

End If

Next Cel

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Run-time error '50290': Application-defined or object-defined erro	Macro button	Excel Discussion (Misc queries)	1	March 12th 09 10:59 AM
Application-defined or object-defined error Please Help	[email protected]	Excel Discussion (Misc queries)	1	April 3rd 06 01:00 PM
Macro error : Application-defined or object-defined error	Joe	Excel Discussion (Misc queries)	3	January 27th 06 02:32 PM
Application-defined or object-defined error	jaf	Excel Programming	0	September 8th 03 07:01 PM
Runtime Error 1004 -- Application Defined or Object Defined Error	John[_51_]	Excel Programming	3	September 4th 03 04:28 PM

All times are GMT +1. The time now is 10:35 AM.

Menu

About Us