The line of code you included your coordinates are wrong. You listed i
as (I, 4). Now if you want cell "I4" as it is in Excel, you need t
change what you have to (4, 8). This is because VBA uses X
coordinates. The first number corresponds to the rows in Excel and th
second to the columns. Assuming I guessed correctly, you want th
fourth cell down in the eight column. Anyway, VBA also lets you us
the format ("I4") in some cases, though not always, so I find it easie
to only use the one way that always works all the time. It cuts dow
on the confusion. - Pikus:
--
Message posted from
http://www.ExcelForum.com