Did FillDown break in 2007??

[Ed from AZ]

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

 

[Jim Cone]

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"
<[email protected]>
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

 

[Ed from AZ]

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

Yesterday wasn't too good for thinking, apparently!

Ed