Moving data with varies in length

[juegen]

Hi,

my code is already working, but unfortunately only at the example where I created it form.

The problem is the the length of the columns varies because the data are measurements.

This causes that an error occurs where it says that the selected data length doesn't fit.

I choose the data blocks with shift+strg+down and shift+strg+right which creates the codes

Please Login or Register  to view this content.

. This should be fine so far, but then the next code is

Please Login or Register  to view this content.

, what might be the problem because it is not flexible and just belongs to the file in which I created the macro in.

I am very new with VBA and would be very glad for any help.

I attached a picture which explains, what I am looking for. The Position of A and B is always the same. C1 and C2 varies. The gap between C1 and C2 is constant as well.

As I mentioned, my code works already, but not in generavorher nachher.pngl, yet.

whole code

Please Login or Register  to view this content.

Thank

[TMS]

Probably best to post a sample workbook with some typical data so the problem can be seen in context.


Regards, TMS

[juegen]

The files are too big. I made them a lot smaller I guess it should work as well.


I just need to know how to select the selected columns and rows in general and not with Selection.

Please Login or Register  to view this content.