Tash Point O
New Member
- Joined
- Feb 12, 2018
- Messages
- 47
Hello -
I made a jenky macro that transposes a large set of data. It runs slow because it's a lot of data that it goes through. So I had the bright idea that I wanted to spend 2 days in a row improving this dumb macro I made. I really tried making this an array or a range type macro and keep failing. Can a transpose macro even be array'ed/range'd?
I want to take the values starting in D1 and say through P1 (because it will vary) and transpose them in the C column under that first value you see (for instance take D1:E1 and move it under c1), then hit the next value in D and do the same, till there no longer is a value in D.
I hate to keep asking for help here and I really tried, but I'm new to declaring dimensions and arrays and I'm ready for a beer at this point. Thank you for any input and insights. I am buying VBA for Dummies after work today.
[/IMG]
I made a jenky macro that transposes a large set of data. It runs slow because it's a lot of data that it goes through. So I had the bright idea that I wanted to spend 2 days in a row improving this dumb macro I made. I really tried making this an array or a range type macro and keep failing. Can a transpose macro even be array'ed/range'd?

I want to take the values starting in D1 and say through P1 (because it will vary) and transpose them in the C column under that first value you see (for instance take D1:E1 and move it under c1), then hit the next value in D and do the same, till there no longer is a value in D.
I hate to keep asking for help here and I really tried, but I'm new to declaring dimensions and arrays and I'm ready for a beer at this point. Thank you for any input and insights. I am buying VBA for Dummies after work today.
