Hoping someone can assist with the code below. I am new at VBA and have been researching ways to achieve this on the net and this is what I have thus far.
Dim LastRow as Integer
LastRow = Sheets("ResultsLog").Range("B" & Rows.Count).End(xlUp).Select
'Copy Entire Row'
If c Is Nothing Then
LastRow = LastRow + 1
Destination:=Sheets("Storage").Range("A" & LastRow)
I am trying to copy the entire row from Sheet "ResultsLog", Range "B4:Y253" if the rows are populated. I want the rows to be copied to the destination sheet "Storage" starting in A2. Data will continually be added to this so it must find the next empty row and paste the data in column A etc.
Once this data has been copied, it needs to clear the contents in "ResultsLog", Range"B4:Y253".
Hope this makes sense. I'm sure I'm totally incorrect with my code, but really did try to give it a go. When I use the recorder it doesn't work.