Can't declare FinalRow

**JapanDave** · 11-12-2011, 10:48 PM

I can't seem to get FinalRow to declare? I am trying to put in a totals row, but it just skips over that bit of code. I am stumped, as I have never had this problem before.

Please Login or Register  to view this content.

The first workbook holds the data, The second brings in the data.You will have to take of the comment tags to get the final row peice of code to run. I have also hard coded the formula to see if it would work, that is why there is two pieces of code doing exactly the same thing.

**protonLeah** · 11-12-2011, 11:40 PM

I don't understand your problem. The code debugs without errors and sets finalrow and finalcol each to one since sheet1 is empty.

**JapanDave** · 11-13-2011, 02:02 AM

Originally Posted by protonLeah

I don't understand your problem. The code debugs without errors and sets finalrow and finalcol each to one since sheet1 is empty.

Ahh, I have been working on this code for too long. Thanks you have pointed out where I was going wrong, I have the finalRow/Finalcol is the wrong place in the code. Now it is working!

Cheers.