Thread: Is there a way to change columns index with Excel 2007,or is it a
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
clau clau is offline
external usenet poster
  
Posts: 7
Default Is there a way to change columns index with Excel 2007,or is it a
I have an Excel workbook that contains a lot of macros in it (programmed with
Excel 97). When I try to excute some code with Excel 2007 the column's index
seems to start at 0 instead of 1.

example: Target.Cells(1,9)... refers to J1 instead of Target.Cells(1,10)

But if I go on the worksheet enter someting in A1 and excute the code again:

Target.Cells(1,9)... refers to I1 and now Target.Cells(1,10) refers to J1.


Any ideas????

Reply With QuoteReply With Quote