Hi there,
This is the first time I have posted on this forum and I would like t
see if anyone can help me with a problem I am having.

I have a stream of values generated by some software that is saved as
.csv file. Each file has several sets of data in this one long list an
I wish to format it differently for ease of viewing and analysis.

Now this is what I have so far:

Columns("A:A").Select
For Each cell In Selection
If cell.Value = "Nr of samples:" Then
-*.Activate*-
ActiveCell.Offset(1, 0).Select
If Selection.Value = "0" Then
MsgBox "This cell has 0"
End If
If Selection.Value = "201" Then
MsgBox "This cell has 201"
End If
End If
Next
MsgBox "Finished looking at all cells"
End Sub

The formatting is easy to do (consists of a few cuts, offsets an
pastes) and I have already written that part (which is going to replac
the MsgBoxs which I have included just for my debugging purposes).
Likewise I am happy with plotting the graphs.

Now, I have the column selected, and I wish to search the column fo
said values (a parameter created by the third party software "Nr. o
samples:"). If these are found I want the cell to move down one fro
that cell (the one being checked), not the current active cell whic
seems to be the top of the range I selected (in this case A1). I kno
that the bold .Activate is the incorrect syntax but I put that in ther
to illustrate what I think I need to achieve (you may well have a bette
way to do it though).

I only have a couple of months self taught experience with VBA an
would greatly appreciate any comments from someone more experience
that may get me going along the right track again.

Anyways,
Thanks in advance

Dav

--
d.i.bar
-----------------------------------------------------------------------
d.i.barr's Profile: http://www.excelforum.com/member.php...fo&userid=1552
View this thread: http://www.excelforum.com/showthread.php?threadid=27092