Adding more rows to the row count from another sheet.

**reddobe** · 08-03-2011, 01:47 PM

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** · 08-03-2011, 02:02 PM

I don't know for sure but try:

Please Login or Register  to view this content.

**royUK** · 08-03-2011, 02:15 PM

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** · 08-03-2011, 02:36 PM

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)