| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a write-multi-cell-at-once function in VBS for Excel?
Check your other post and make sure you qualify all those range objects
(.range() and .cells()). Tony Bansten wrote: As well known I can write into an Excel cell a certain value with in a VBS script with e.g. objWorksheet.Cells(2, 5).Value = 55 Can I write the value 55 into multiple cells at once? Imagine I want to write in all cells 2,5 .... 2,37 the value 55. Do I really have to iterate through all cells individually or is there a function like objWorksheet.multiCells((2,5),(2,37)).Value = 55 ? Tony -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a write-multi-cell-at-once function in VBS for Excel? | Excel Discussion (Misc queries) | |||
| Write a function in a split cell. | Excel Programming | |||
| How do I write the IF function to reflect the result in one cell? | Excel Worksheet Functions | |||
| how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
| Write a function call into an Excel cell from VBA | Excel Programming | |||
Threaded Mode
