View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
pikus pikus is offline
external usenet poster
 
Posts: 1
Default SubScript Out Of Range.

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