LinkBack URL
About LinkBacks
I can't seem to get resize to work when transposing values.
It always just populates the resize number with the value of the first cell in the range. How do I transpose using this method?
Cheers
Please Login or Register to view this content.
I can't seem to get resize to work when transposing values.
It always just populates the resize number with the value of the first cell in the range. How do I transpose using this method?
CheersPlease Login or Register to view this content.
Last edited by JapanDave; 02-17-2012 at 07:17 AM.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
hi Dave, sort of that
Please Login or Register to view this content.
Last edited by watersev; 02-17-2012 at 05:13 AM.
Hey Watersev,That did the trick! Thanks.
To build on Watersev's answer, you could make that variable, if there are no gaps:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks