Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » Writing to Noncontiguous Ranges with VBA

Writing to Noncontiguous Ranges with VBA

Mike comments: I’m wondering if this same Array -> Range approach will work with a non-contiguous range? For example we have an application at work that needs to write around 400 values into an Excel sheet (it does this via ActiveXObjects from the browser. Yuck, I know). At present it does this in a loop calling .cell(row, [...] Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2010/11/03/writing-to-noncontiguous-ranges-with-vba/

Posted Nov 03 2010, 09:20 AM by Daily Dose of Excel
Filed under: ,
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.