Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I use arrays to fill ranges with values all the time because is it is so fast.
targetRange = myarray Is there any equivalent (or alternative method) for adding a large number of comments without having to loop through every location in the target range. It would be nice if the following worked but it doesn't targetRange.text = myarray Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mass adding of text | Excel Worksheet Functions | |||
Inserting Comments en mass | Excel Discussion (Misc queries) | |||
adding up COMMENTS | New Users to Excel | |||
Adding comments | Charts and Charting in Excel | |||
2 files, mass update comments between files | Excel Worksheet Functions |