I need to copy a range of cells and paste the data into another sheet and run this within my macro. The trick is I need to copy to the last row that has data – and the real kick is (if possible) ignore if a cell is empty but instead go until a row is found empty!
This is what I am using now – but it stops once it finds an empty cell (obviously)
With Sheets(fullData)
Range(“J6”, Range(“N6”).End(xlDown)).Copy
End With
Thank you for the help!
