I was "upgraded" to 2007. Why doesn't this work??

If Target.Column = 4 And _
Target.Row <> 21 Then
x = Target.Row
y = Target.Column

With wks
.Range(x, y + 1).FillDown

Method 'range' of object "wks" failed????

Ed

wks.Range(x, y +1) is not a range object.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Ed from AZ"
<(E-Mail Removed)>
wrote in message
I was "upgraded" to 2007. Why doesn't this work??

If Target.Column = 4 And _
Target.Row <> 21 Then
x = Target.Row
y = Target.Column

With wks
.Range(x, y + 1).FillDown

Method 'range' of object "wks" failed????
Ed

Yeah - it hit me this morning! That should have been Cells instead of
Range.

Yesterday wasn't too good for thinking, apparently!

Ed


On Jun 4, 6:36*pm, "Jim Cone" <james.cone...@comcast.netXXX> wrote:
> wks.Range(x, y +1) is not a range object.
> --
> Jim Cone
> Portland, Oregon *USAhttp://www.realezsites.com/bus/primitivesoftware
> (Excel Add-ins / Excel Programming)
>
> "Ed from AZ"
> <prof_ofw...@yahoo.com>
> wrote in message
> I was "upgraded" to 2007. *Why doesn't this work??
>
> If Target.Column = 4 And _
> * *Target.Row <> 21 Then
> * x = Target.Row
> * y = Target.Column
>
> * With wks
> * * .Range(x, y + 1).FillDown
>
> Method 'range' of object "wks" failed????
> Ed