peace all,
with the code :=
how to check individual range from above if blank or not, and then apply deletion to that particular range.
for instance
1:1 = not blank, then skip code
51:51 = blank, then delete shift:=xlUp
101:101 = not blank, then skip code
151:151 = not blank, then skip code
with the code :=
Code:
Range("1:1,51:51,101:101,151:151").Delete Shift:=xlUp
how to check individual range from above if blank or not, and then apply deletion to that particular range.
for instance
1:1 = not blank, then skip code
51:51 = blank, then delete shift:=xlUp
101:101 = not blank, then skip code
151:151 = not blank, then skip code