Finding the last row with data using vba <p><strong>I am creating a program in which everytime it generates, the generated data will appear in a specific sheet and arranged in specific date order . It looks like this.</strong></p> <p><a href="https://i.stack.imgur.com/1vUeq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1vUeq.png" alt="Generated data"></a></p> <p>But when I generate again, the existing data will be replaced/covered by the new data generated. Looks like this.</p> <p><a href="https://i.stack.imgur.com/KM55r.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KM55r.png" alt="enter image description here"></a></p> <p>Now my idea is, before I am going to paste another data, I want to find out first what is the last used cell with value so that in the next generation of data, it wont be replaced/covered by the new one. Can someone help me with this. The output should look like this.</p> <p><a href="https://i.stack.imgur.com/YLXnq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YLXnq.png" alt="enter image description here"></a></p> <p>Any help everyone? Thanks! </p>