i need to write a macro which takes 100 entries in column in an excel spreadsheet and turns it into a 10x10 matrix on either the same or another sheet.
in vba code:
How do i read the first 10 entries in a column then cut and paste them into another column,
then take the next 10 down of the 90 that are left and put them in the column to the right of
the first 10 i took away.
Then what happens when theres 110 in the column and i need to have a 11x10 matrix?
cheers
Last edited by intothewild; 09-25-2011 at 06:58 PM. Reason: clarity
The following code will take any number of cells in column A of the active sheet and use them to make a matrix 10 rows high on the named sheet.
Please Login or Register to view this content.
cheers Andrew-R
Please Login or Register to view this content.
....can you explain a little how the 'With' section works im not so sure i follow it..
Last edited by intothewild; 09-25-2011 at 06:41 PM.
It just tells Excel which object you're working with, once you've made a with statement any properties or methods belonging to the object can be referred to by proceeding them with a period.
So, for example:
Please Login or Register to view this content.
Does the same as:
Please Login or Register to view this content.
As I'm working with the active sheet the with statement probably wasn't needed, it was just force of habit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks