BradleyS
Active Member
- Joined
- Oct 28, 2006
- Messages
- 344
- Office Version
- 2010
- Platform
- Windows
I have a table of data in one column called "MyData" and currently set as Worksheets("Data").Range("H39:H49")
The objective is to get the column of data into a comma separated variable
However, I don't seem to be able to find a way to use the table name in my transpose formula below
I'm trying to substitute the range to use a table name, as the table is dynamic, so the range will change
How do I covert this formula (which works fine) to use my table name?
Dim x As Variant
x = Join(Application.WorksheetFunction.Transpose(Worksheets("Data").Range("H39:H49").Value), ",")
as the below doesn't work, and various other methods I have tried to use.
x = Join(Application.WorksheetFunction.Transpose(MyData.Value), ",")
The objective is to get the column of data into a comma separated variable
However, I don't seem to be able to find a way to use the table name in my transpose formula below
I'm trying to substitute the range to use a table name, as the table is dynamic, so the range will change
How do I covert this formula (which works fine) to use my table name?
Dim x As Variant
x = Join(Application.WorksheetFunction.Transpose(Worksheets("Data").Range("H39:H49").Value), ",")
as the below doesn't work, and various other methods I have tried to use.
x = Join(Application.WorksheetFunction.Transpose(MyData.Value), ",")