Hi
I am having real trouble to find away to solve the below problem - any pointers will be greatly appreciated.
I would like VBA to search column C and delete the 2 Rows above if there is a 2, 4 rows if a 4 etc.
c
x
x
2
x
x
x
x
4
x
x
2
Hi
I am having real trouble to find away to solve the below problem - any pointers will be greatly appreciated.
I would like VBA to search column C and delete the 2 Rows above if there is a 2, 4 rows if a 4 etc.
c
x
x
2
x
x
x
x
4
x
x
2
So should the code check for all numbers and delete the rows above it depending on the numbers?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
This basicly what the code should look like. It's based on what you have on your post.
![]()
Please Login or Register to view this content.
aelgadi
> Click Star if I helped. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks