I'm a VBA rookie, so sincere apologies if this is a bad post.
I have a macro that will take many years in its current state. I cannot figure out how to implement assignment (or any faster method that avoids copy/paste) with both transposing and range offsets.
Please see below an extract of my very slow code. How can I assign values instead of copy/paste?
Please Login or Register to view this content.
Bookmarks