| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 How to change width of stacked columns | Charts and Charting in Excel | |||
| How do I change a long columns list to short ones in 2007 Excel? | Excel Discussion (Misc queries) | |||
| Varied Results obtained using Index and Match in Excel 2003 and 2007 | Excel Worksheet Functions | |||
| Index and Match results vary in Excel 2003 and 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 extra columns - but transposing columns still not working! | Excel Programming | |||
Threaded Mode
