-
select a range using 2 address and find if range is empty/has data
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules