Hello,
I am trying to use VBA to reference a cell range and display on a different sheet with 4 spaces between the displayed values starting at a specific cell.
See the example clip below to see what I am trying to do. Please help?
Capture.JPG
Hello,
I am trying to use VBA to reference a cell range and display on a different sheet with 4 spaces between the displayed values starting at a specific cell.
See the example clip below to see what I am trying to do. Please help?
Capture.JPG
Last edited by mrjackg; 03-10-2017 at 08:23 PM. Reason: Added detail of what I am trying to do
Here is one way to do it...
Please Login or Register to view this content.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Thats great thanks. Is there a way to start the destination at a specific cell say C4?
Thanks again!
Jack
Sure, where it has i=1 change that to i=4
Right too easy. Thanks again
I dont suppose you could help me with one more thing? If I wanted to filter the source range to only select cells that Dont have some specific text in it, could you advice on the vba to be used here?
See example I dont want the cells with the text showing _WorkPlan at the end the the name:
Capture.JPG
Sure...
Please Login or Register to view this content.
Awesome so simple. Thanks again
This is another solution using arrays
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Another option for your first post.
Change the cell reference, here K7, to wherever you want to start your paste
Please Login or Register to view this content.
YaserKhalil : this is very good..copy paste use ing array but is posibel also copy format use array
Thanks a lot ..
ASAIK using arrays doesn't keep format and if you need to use formats you would deal directly with cells
Another possibility for your Post #6
No looping. Size of Range will determine speed I think.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks