Copy contents of Cell to array based on Col1 value not null

M

missleigh

I am trying to write a macro to read through a Read through a range of
cells (currently A2:J13), where A1 is not empty, select the contents of
A2 and E2 and write them to an array.

Ideally, this data would then be populated on a separate sheet.

So far I have:

+++++++++++++++++++++++

Sub TestStatusArray()
Dim TestCaseID As String
Dim Status As Boolean
Dim R As Integer
R = 2

Do While Not (IsEmpty(Cells(R, 1)))
Cells(R, 1).Copy << getting lost here


Loop
End Sub

+++++++++++++++++++++++

I can't seem to figure out how to extract the contents of the cells and
and write
A2 to TestCaseID and E2 to Status.

I welcome any suggestions/recommendations/reading links.

Thanks,
Leigh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top