Optional Rowoff and Coloff parameters, allowing the data to be offset from the top-left corner of the specified range.This may be useful if the range to be written is smaller than the old range, and you wish to keep the old data outside the limits of the new array. Optional “ClearRange” parameter, allowing the data in the named range to be cleared before writing the new data.Optional “NumRows” and “NumCols” parameters, allowing part of the array to be written to the spreadsheet (default is write the whole array). I have now put this code in a function that can be conveniently called from any other VBA routine, with several optional features: Previous posts have looked at the VBA code for efficiently writing a VBA array to the spreadsheet as quickly as possible, most recently here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |