Transposing data from Row to Column drama's

[coreytroy]

I am trying to transpose some data in a found row to a sheet column (C), but cannot get the syntax correct.

Please Login or Register  to view this content.

The only result is a column full of Zero's for some reason.

[JapanDave]

I have no idea what you are trying to do, but this fixes any of the mistakes in your code.

Please Login or Register  to view this content.

[coreytroy]

I have added a simple example of what i am doing.

[JapanDave]

Why are you trying to offset values to this much in the code below?

Please Login or Register  to view this content.

[coreytroy]

Why are you trying to offset values to this much in the code below?

Please Login or Register  to view this content.

The example file is an EXAMPLE.

The actual workbook needs the offset 668 to 773, the example workbook is only a small example offset.

[JapanDave]

It is very hard to see what you are doing in the real file as the sample book does not tie in with the first macro?

I can transpose the data for the sample book, but I still have no clue what you are trying to transpose in the real file???

[coreytroy]

I can transpose the data for the sample book, but I still have no clue what you are trying to transpose in the real file???

What would the Transpose code for the example file ?

I could probably adapt it..

[JapanDave]

Try this, Click the add data button you had made.

[coreytroy]

I will have a look at it in the morning, thanks.