Hello,

I am trying to use two dates (start and end dates which I currently have the address and column number for) and find out if within that row range if there is data or not. This would be within a loop that would iterate and check each row. If its empty leave it, if its got data transfer to another sheet.
I have been playing with a series of ideas but no luck. Can you suggest a method on how to do this?

To start, I want to get the range part of code correct but to no avail:
With Worksheets("Sheet1").Range(Cells(3, columnnumberstart), Cells(5, columnnumberend)).Select

Heres one idea I have:
for loop
If IsEmpty(Range(Cells(6, columnnumberstart), Cells(6, columnnumberend))) = True Then
copy range
endif


Thank you
Michael

End If