PDA

View Full Version : Solved: finding row and skipping over data



Sunswan
04-19-2013, 09:21 AM
Hello All, I have been working with VBA for about a month and am need of some help. What i would like to know is how to find a row (ie A6) , add some data to it in (D6), but id D6 has data move to E6. How is this done. I would like to find the answer so I can go through it and find out how it works. Thanks for any replies.

zagrijs
04-30-2013, 04:58 AM
activesheet.range("A6").activate 'moves to desired row
or
activesheet.cells(6,1).activate

if Range("D6").value = empty then
Range("D6").value = "The value you want to enter"
else
Range("E6").value = "The value you want to enter"
end if.

You do not have to move to row 6 to enter the information.

Sunswan
04-30-2013, 04:48 PM
Thanks for the reply. I figured it out and forgot to closed this forum. Thanks for the interest though.