Did FillDown break in 2007??
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
|