Macro goes to A1 automatically

[pisco]

Hello guys,

why does this macro go to the cell A1 automatically and gives me this table:

Please Login or Register  to view this content.

tar.PNG

I appreciate your answer!

[Norie]

When I run the code on a blank sheet the selected cell stays where it was and I get a table of 0s.

[PCI]

You are asking, with the macro to start filling cells(2,2) ( which is B2) and then to scroll by rows and by columns
Certainly first column and first row have already some values , is it?

[pisco]

@Nori
Like that I guess:

zero.PNG

My question is probably quite newbish. What I do not get is, why are always the cells in the upper left corner selected with values?

Thx in advance for your reply!

[pisco]

You are asking, with the macro to start filling cells(2,2) ( which is B2) and then to scroll by rows and by columns
Certainly first column and first row have already some values , is it?

Thx for your answer! I do not get why only these cells get filled and not others?(even when I have no values in it)

[Norie]

pisco

The code you posted doesn't select anything.

It loops from B2 (Cells(2,2)) across to F2 (Cells(2,6)) then goes down to B3 (Cells(3,2)) and across to F3(Cells(3,6)) and so on.

As it goes it multiplies the value from row 1 in the corresponding column with the value from column A in the corresponding row.

This might show you what's being multiplied.

Please Login or Register  to view this content.

[pisco]

Thx for your answer! I get it now!

[PCI]

You could also go step by step in the macro using key F8 and see what's happening in the sheet