Did FillDown break in 2007??
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 |
Did FillDown break in 2007??
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 |
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 |
All times are GMT +1. The time now is 12:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com