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"

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" 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"

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