>If you want to jump and write your data from a RANGE of ("A3:F3") to ("H3:M3") how would you do this numerically? When you finish your first month in the first range, you then start the 2nd month in the next range of H3:M3, then the 3rd month further to the right likewise.
>
>I have 12 months of data I must show across the spreadsheet from left to right. Since the columns are using alpha characters, is there a way with automation to make the jump using numbers?
>
>Cecil
You can address the cells by row and column
ExcelObject.ActiveWorkBook.Sheets[1].Cells(rownumber, columnnymber).Value = 123
Gregory