Posted to microsoft.public.excel.programming

Kevin Baker[_2_] Kevin Baker[_2_] is offline

external usenet poster

Posts: 13

Can't Seem to find problem with this VBA Code

If Target.Column = 6 And Target.Value 1 And Target.Offset(0, 2).Value 1
Then
Target.Offset(0, 3).Value = Target.Value - Target.Offset(0, 2).Value
ElseIf Target.Column = 8 And Target.Value 1 And
Target.Offset(0, -2).Value 1 Then
Target.Offset(0, 1).Value = Target.Offset(0, -2).Value - Target.Value
End If

I get the following when entering data in Cell A on a new line:
"Run-Time error '1004'
Application-defined or object-defined error

Any thoughts?
Kevin

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
Code to find code	D.	Excel Discussion (Misc queries)	2	August 12th 07 06:16 PM
Find last row code	Mike Milmoe	Excel Discussion (Misc queries)	2	June 11th 07 08:48 PM
cannot find code	Gail Hines	Excel Programming	3	December 6th 04 10:05 PM
Help with this Find code please	[email protected]	Excel Programming	2	December 18th 03 03:05 AM
VBA Code to FIND	Christine[_4_]	Excel Programming	3	July 17th 03 08:24 PM

All times are GMT +1. The time now is 05:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us