Pasting the specified range using vba

**Szwadron6** · 03-03-2017, 09:48 AM

Hello,

For now whenever I wanted to create a value in vba I used the formula

Please Login or Register  to view this content.

However now I would like to populate a little bit more of cells. Is there a way to put values like that:

Please Login or Register  to view this content.

using a more simple code than multiplying RAnge.Method over and over again? Let's say I would like those values starting from Cell A1.

Many thanks in advance.

**Kaper** · 03-03-2017, 10:14 AM

Try such approach: write all data into one string, separating elements in columns by (for instance) comma, and end each row by (for instance) semicolon.
Then use split to create array of one_row strings and split again to separate all entries for given row into separate columns.

Enjoy:

Please Login or Register  to view this content.

Pasting the specified range using vba

LinkBack

Thread Tools

Rate This Thread

Display

Pasting the specified range using vba

Re: Pasting the specified range using vba

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Pasting into a Range instead of last used row

Pasting to dynamic Range

[SOLVED] Pasting A Range Into Next Available Row

[SOLVED] Copying Active Cell-Row-Range to Other Workbook is pasting an image of copied range

Naming a range and then pasting a value into that range

[SOLVED] Pasting in a range

[SOLVED] Pasting Values of range to another range

Bookmarks

Bookmarks

Posting Permissions