writing a range to an array then writing the array to a new range

**prjames3** · 12-15-2014, 08:04 PM

I'm trying to write a range into an array so I can then write that array into a new range. I keep getting an "Application-defined or object-defined error" on the line "columnData = Worksheets("start").Range(Cells(rowFirst, column(1)), Cells(rowLast, column(1))).Value."

Please Login or Register  to view this content.

rowFirst, rowLast, column() are all integer variables.

Thanks for any help.

**prjames3** · 12-15-2014, 08:07 PM

I made a typo above. "columnData()" has a "()" in its declaration.

**Norie** · 12-15-2014, 08:38 PM

It's Columns not Column.

**mikerickson** · 12-15-2014, 08:57 PM

If you want the range to be in column A, then use.
(I haven't tested, but you might need to Dim ColumnData as Variant rather the as an array)

Please Login or Register  to view this content.

writing a range to an array then writing the array to a new range

LinkBack

Thread Tools

Rate This Thread

Display

writing a range to an array then writing the array to a new range

Re: writing a range to an array then writing the array to a new range

Re: writing a range to an array then writing the array to a new range

Re: writing a range to an array then writing the array to a new range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] New to arrays-Resizing cell range when writing array

writing formula in range on each sheet via array

Writing Multi-Dimensional Array To Range

[SOLVED] Writing a range to an array...

Writing to An Array or Collection

Bookmarks

Bookmarks

Posting Permissions