| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
bulk transfer of comments using a range
I'm trying to add comments to a range rather than one by one as follows...
Range(Cells(lRow, lOrigCol), Cells(lRow, lCol)).Comment = aRowComment ....in an effort to get better run times but get the following error object variable or with block variable not set ....when I append .Text on the end of the command I get a compile error saying assignment to a constant not permitted aRowComment is an array of comments, built similarly to the array of values currently transferring to the range with no problems. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to transfer specific range to another range ? | Excel Discussion (Misc queries) | |||
| adding colors, patterns, comments to large spreadsheets in bulk | Excel Programming | |||
| How to transfer emails from excel to bulk mailer | Excel Discussion (Misc queries) | |||
| ADO Excel to Access - bulk transfer of array? | Excel Programming | |||
| Named Range Transfer | Excel Discussion (Misc queries) | |||
Threaded Mode
