Range: a1:c10. 3 columns.
A row is considered blank if it has no data in all 3 columns.
the result should be
Range("ax:cy").Copy
Thanks
Range: a1:c10. 3 columns.
A row is considered blank if it has no data in all 3 columns.
the result should be
Range("ax:cy").Copy
Thanks
May be
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
1. I fail to see where the copy command is.
2. cannot do entire Row delete, there is adjacent data in other columns.
Can you upload sample workbook to see the structure?
Nothing special...
a1:c4
test
1 2 3
z x c
5 6
This is an example. Reference in code is always made to the entire a1:c10 range.
Not clear for me. Waiting for others to share
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks