Loop through sheets error

Hi,

I'm new to VBA and I have a problem with a macro I created. I am trying to loop through all the worksheets in the workbook paste some formulas, do a calculation, take that calculation and place it in a worksheet at the end of the workbook and place the value into the first empty cell in column "A" of the worksheet. The problem is when I run the code I get an error on the destination line:

Please Login or Register  to view this content.

What am I doing wrong?

Here is the complete code:

Please Login or Register  to view this content.

Thanks

Hi, JM5,

please add code-tags when showing procedures where on Excel Forum.

You start at the last cell and want to go further down - no chance there:

Please Login or Register  to view this content.

You could check the last cell for any entry:

Please Login or Register  to view this content.

Ciao,
Holger

You may put the value directly:

Please Login or Register  to view this content.

Hi @JM5,

Please add code tags to your first post and mark the thread as solved.

Thanks.

abousetta