Hello. Could someone please walk me through in detail what each part of this code is doing? Thanks
![]()
Please Login or Register to view this content.
Hello. Could someone please walk me through in detail what each part of this code is doing? Thanks
![]()
Please Login or Register to view this content.
Looks strangely familiar ...
The first bit copies a range into an array based on the nimber of rows of data in column E.
The outer loop processes each "column" in the array.
The inner loop process each "row"/"cell" in the "column". If the value is 0, it replaces it with blank/null (""). If it is not zero, it exits the inner loop.
The last part then copies the array back to the worksheet having replaced all zeroes below a non-zero value with blanks.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks