Posted to microsoft.public.excel.programming

JLGWhiz

external usenet poster

Posts: 3,986

Worksheet_Change

Can anybody see why the object variable will not set? I can't, but it won't.
Appreciate another set of eyeballs looking at this.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim isect As Range
Set isect = Application.Intersect(Target, Range("E:E"))
If isect 0 Then
Me.Range("B" & Target.Row).Value = Me.Range("C" & Target.Row).Value
End If

End Sub

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
about worksheet_change	ViestaWu	Excel Programming	5	July 4th 07 05:08 AM
Worksheet_change	Andrew haycock	Excel Programming	2	September 3rd 03 05:32 PM
worksheet_change vs. calculate, and worksheet_change not running	Tom Ogilvy	Excel Programming	1	July 14th 03 02:51 AM
worksheet_change vs. calculate, and worksheet_change not running	Ross[_5_]	Excel Programming	0	July 13th 03 04:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us