Proiblem Transposing Named Range Data To A Column

[Ark68]

I have a range of cells to which they have been assigned a name of "modlist". It contains approx. 1000 values.
The snippet of code below is supposed to transpose those values of "modlist" to the cells of column AB starting at a specific cell determined by the value of drow calculated earlier. (drow = 4). In this example, the values of "modlist" will be transposed starting at AB4.

The code does transpose to AB4, however, instead of each individual value in "modlist", it transposes 1000+ instances of the first value of thousands. So if the first value in "modlist" was Giraffe, 1000+ instances of Giraffe is applied to the column at AB4.

...
drow = (.Cells(.Rows.count, "AB").End(xlUp).Row) + 1
Set sourceRng = ThisWorkbook.names("Modlist").RefersToRange
Set targetRng = .Cells(drow, 28)
transposedData = Application.WorksheetFunction.Transpose(sourceRng.Value)
targetRng.Resize(UBound(transposedData), 1).Value = transposedData
...

 

[Fluff]

I have a range of cells to which they have been assigned a name of "modlist".

What range?

 

[Ark68]

Hello Fluff. A dynamic range of cells from worksheet ws_modlist.range("M2:M1247") was given the name "modlist" earlier in my project. A look at that name in name manager reveals the proper range and the values of all cells. Only the 1st value in that named range is being transposed 1247 times.

 

[Fluff]

Then why are you trying to transpose that into another vertical range? Or should it be transposed to a single row?

 

[Ark68]

I think only for the purposes of learning about how I can use names. I could copy and paste that range as an option, but this is how I'm learning that this method may not work.

I'm using that existing range of cells and adding it to the end of other data to create a new list. Taking the range M2:M1247 to data at the end of column AB.

 

[Fluff]

The problem is not the named range, it's that you are trying to transpose a single column into another single column.
If you transposed it into a single row, then it would work.

 

[Ark68]

Ah, i see. Transpose takes vertical data and makes it horizontal or vice versa?

 

[Fluff]

That's right.