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

Please Login or Register  to view this content.

[Mordred]

I don't know for sure but try:

Please Login or Register  to view this content.

[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)