Visual Basic: looping a copy / paste and transpose function

[Frey]

Hello to everybody,

I have an excel sheet in which the diagonal cells (B3, C4, D5, E6 ecc ecc) are locked.

I want to copy from C3 to M3, than paste (values) and transpose on from cell B4 to B12.

I recorded a macro that does this

Please Login or Register  to view this content.

but I am not able to programme the code in order to execute a second action starting this time from range "D4:M3" and paste/transpose to cell C5.

I would like to loop this action untill cell M11 and copy paste only that last single cell in L14 (this is an example, I have to this for hundreds of rows actually....)

I tried some loop commands but the action goes on infinitely without skipping the diagonal cells and moeover without stopping.

Thank you it would be great to receive a visual basic code!

[gmk]

Hi Frey

Try this.

Please Login or Register  to view this content.

[gmk]

Frey

You mentioned the cells were locked which I assume you mean protected?
This will take care of that.

Please Login or Register  to view this content.

[Frey]

GREAT! Thank you! The first code you sent me works perfectly!

[gmk]

Frey

The first code you sent me works perfectly!

That implies the second does not. I'm a bit puzzled. There is little difference excepting the Unprotect, Protect and a password of your choice. So the second code should work as well.
If the second does not work have you substituted your own password where appropriate?
Are you clear about what 'locked' means i.e. 'not able to be modified'? A cell is only truly locked when the wsheet is Protected.

[Frey]

Hello gmk,

actually you are right and you saw my error :-) I did not put my password in the code! Thanks again for the help, it works!

Kind regards