software

Hi-

I have a formula starting in Row7 and continuing to the end of the
spreadsheet. How can I copy the formula in Row7, copy and paste and have the
formula used in all additional Rows at the bottom of my sheet?

I tried the nifty Ctrl-Space bar, but it takes Rows 1-6 also, they are
header rows and do not get the formula.

I tried a simple copy/paste, which works, but doesn't continue for
additional rows beyond what I specified in the copy.

I do have the Options set to extend list formats and formulas - maybe this
is not a list?

I'm using 2003.

Thanks in advance.

DTTODGG wrote:
gt; Hi-
gt;
gt; I have a formula starting in Row7 and continuing to the end of the
gt; spreadsheet. How can I copy the formula in Row7, copy and paste and
gt; have the formula used in all additional Rows at the bottom of my
gt; sheet?
gt;
gt; I tried the nifty Ctrl-Space bar, but it takes Rows 1-6 also, they are
gt; header rows and do not get the formula.
gt;
gt; I tried a simple copy/paste, which works, but doesn't continue for
gt; additional rows beyond what I specified in the copy.
gt;
gt; I do have the Options set to extend list formats and formulas - maybe
gt; this is not a list?
gt;
gt; I'm using 2003.
gt;
gt; Thanks in advance.

I have a utility in my PERSONAL.XLS which I have attached to Ctrl-M. This
takes marked cells and copies them down to the bottom of a table.

Sub copy_down_block()
'Ctrl-M
Range(Selection.Cells(1, 1), Selection.Cells(Cells.Find(What:=quot;*quot;,
SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row - Selection.Row 1,
Selection.Columns.Count)).FillDown
End Sub