<div>
can this work even if it is non adjacent cells?<br />
<br />
liek this Range(&quot;C17, D18, R11, W27&quot;)
</div>


can this work even if it is non adjacent cells?

liek this Range("C17, D18, R11, W27")

<div>
<div class="content wysiwyg-content">
i want to use vba to update these non adjacent cells value to &quot;OK&quot; &nbsp;but this method is not working <br />
<br />
wb.Worksheets(1).Range(&quot;C1<wbr />7&quot;, &quot;C18&quot;, &quot;C19&quot;, &quot;C20&quot;).Value = &quot;OK&quot;<br />
<br />
how can i make this work?
</div>
</div>


i want to use vba to update these non adjacent cells value to "OK"  but this method is not working 

wb.Worksheets(1).Range("C17", "C18", "C19", "C20").Value = "OK"

how can i make this work?

wb.Worksheets(1).Range(&quot;A17&quot;, &quot;B18&quot;, &quot;R19&quot;, &quot;S20&quot;).Value = &quot;OK&quot; Does not work

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

wb.Worksheets(1).Range(&quot;A17&quot;, &quot;B18&quot;, &quot;R19&quot;, &quot;S20&quot;).Value = &quot;OK&quot; Does not work

wb.Worksheets(1).Range("A17", "B18", "R19", "S20").Value = "OK" Does not work