So, if I need to set the initial and subsequent RANGE() for laying out data, I could do something like initialize a variable for Row and one for Column and use them in the CELLS proeprty instead of an ALPHA Column and Number?
Cecil
>>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