I am trying to create spreadsheets via FoxPro into excel. I am able to get the data into the spreadsheets. The problem I am having is formatting the spreadsheet. I want to add underlines, subtotal, etc. The number ofrecords in my files constantly changes. So a formula that might fit in cell F35 on one day may need to be moved down to F60 or something the next day. This is what I have
> so far.
>
> With objExcel
>
> .Sheets("DC").Activate
> .Cells(1,1).select
> .Selection.End(xlToRight).select
> .selection.end(xldown).select
>
> This positions me at the end of the data block. I want to move down from here two or three cells and put a formula in place that will sum the entire column. I think I need to load the coordinates into a variable and add "two or three places" to that so it positions the cursor where I want the formula. How do I do that? Any ideas. Samples would greatly be appreciated