Pls Help!!

[boris2004]

Hello

i need to check a row for data and if that data is their i need to the
check the next row and if the data isnt their then i need to put th
data in that range

i know how to add the data using VBA but i dont know how to check tha
row for the data and if it does exist i need to goto the next row


Hope this helps,
Jami

 

[Don Guillett]

for each c in selection
if c="mydata" then c="mydata"
next c

 

[Alan Beban]

Here's one way:

Sub test3001()
Dim n As Long
n = 4
If Application.CountA(Rows(n)) Then Rows(n + 1).Select
End Sub

Alan Beban