VBA code needed to move row if cell has value

[lasusa]

I have been unsuccessful locating code that will move a row of data to the bottom of a list once a cell is populated.

I don't think this is difficult to do but I am struggling.

-C

 

[Martin1991]

So should I understand it is an alternative for a Dim, but assigned directly to the Private Sub criteria? Not sure if i wrote it correct: Like it shouldn´t matter, if I use

Private Sub aaa(ByVal Target As Range)

or

Private Sub aaa()
Dim Target As Range

?
Anyway still thanks for answer.

 

[L. Howard]

So should I understand it is an alternative for a Dim, but assigned directly to the Private Sub criteria? Not sure if i wrote it correct: Like it shouldn´t matter, if I use

Private Sub aaa(ByVal Target As Range)

or

Private Sub aaa()
Dim Target As Range

?
Anyway still thanks for answer.

For some better input on this I suggest you post a new thread using "What is (ByVal Target As Range)..." etc. in the title. Many others are can give you a good explanation and perhaps some examples on this subject.

Howard

 

[Martin1991]

Ok, i will try it, thanks.