<div>
Can you provide more detail. Do you want the values in G4, G5, H4, H5 etc (until you find a blank) in an array? Or G4, H4 etc in one array and G5, H5 in another? Or G4, H4, G4, G5...?
</div>


Can you provide more detail. Do you want the values in G4, G5, H4, H5 etc (until you find a blank) in an array? Or G4, H4 etc in one array and G5, H5 in another? Or G4, H4, G4, G5...?

<div>
The first one. G4,G5,H4,HG etc in one array until i come across a blank
</div>


The first one. G4,G5,H4,HG etc in one array until i come across a blank

<div>
Hi,<br />
<br />
I have to write this code in another worksheet. How do I modify this code so that it loops another worksheet.<br />
<br />
Thanks
</div>


Hi,

I have to write this code in another worksheet. How do I modify this code so that it loops another worksheet.

Thanks

<div>
Adjust sheet name as required:<br />

<pre><code id="code-20-36181245-1">Sub x()

Dim v(), c As Long, i As Long

c = 7

Do Until IsEmpty(Sheet(&quot;Name&quot;).Cells(4, c))
    i = i + 2
    ReDim Preserve v(1 To i)
    v(i - 1) = Sheet(&quot;Name&quot;).Cells(4, c)
    v(i) = Sheet(&quot;Name&quot;).Cells(5, c)
    c = c + 1
Loop

End Sub</code></pre>
</div>


Adjust sheet name as required:


Sub x()

Dim v(), c As Long, i As Long

c = 7

Do Until IsEmpty(Sheet("Name").Cells(4, c))
    i = i + 2
    ReDim Preserve v(1 To i)
    v(i - 1) = Sheet("Name").Cells(4, c)
    v(i) = Sheet("Name").Cells(5, c)
    c = c + 1
Loop

End Sub

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have an excel sheet and I want to pick up headings from row 4,row 5 column G onwards in an array in visual basic.<br />
Also the array I create has to be dynamic as I do not know beforehand how many columns to go beyond G. I have to stop before the point it becomes blank<br />
How do I do it?<br />
<br />
Thanks<br />
<br />
Shilpi
</div>
</div>


Hi Experts,

I have an excel sheet and I want to pick up headings from row 4,row 5 column G onwards in an array in visual basic.
Also the array I create has to be dynamic as I do not know beforehand how many columns to go beyond G. I have to stop before the point it becomes blank
How do I do it?

Thanks

Shilpi

Picking column headings

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.