Adding more rows to the row count from another sheet.

[reddobe]

The code below works to copy the formulas down based on the number of rows on the Items sheet. But, the Data sheet has 9 rows of header data so I need to add that amount of rows to whatever the count is from the Items sheet. Any help would be appreciated

Sub CopyDataFormulasDown()
'
' CopyDataFormulasDown Macro
'
' Keyboard Shortcut: Ctrl+Shift+D
'
    Range("A2:C2").AutoFill Destination:=Range("A2:C" & Worksheets("Items").Cells(Rows.Count, "A").End(xlUp).Row)
End Sub

[Mordred]

I don't know for sure but try:

Sub CopyDataFormulasDown()
'
' CopyDataFormulasDown Macro
'
' Keyboard Shortcut: Ctrl+Shift+D
'
    Range("A2:C2").AutoFill Destination:=Range("A2:C" & Worksheets("Items").Cells(Rows.Count, "A").End(xlUp).Row+9)
End Sub

[royUK]

Rows.Count only refers to the maximum number of rows on any sheet. It can't change unless you specify a particular range.

Prior to Excel 2007 - 65536, over 1,000,000 in later versions

It's pointless specifying a different sheet, you can't increase rows beyond the maximums set by MS

[reddobe]

Mordred, That worked. It was the only place I didn't add the + 9, figuring I needed to stay inside the main part of the code (near the count cells portion)