ExcelBanter - Assigning array to range inside Excel Object

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Assigning array to range inside Excel Object (https://www.excelbanter.com/excel-programming/293868-re-assigning-array-range-inside-excel-object.html)

Jon Peltier

Assigning array to range inside Excel Object

Too busy copying and pasting, and not thinking!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Tom Ogilvy wrote:

this is an odd construct:

With xlapp.wkbk.wksht

a wksht with no parent?
a wkbk with no application?

All times are GMT +1. The time now is 07:56 PM.