My range is e12:e734 (e734 will change every time, but column will not change). Find nonblank cell for example E14 then formula in h14=1-(G14/(F14*E14)). Then I have to filter non blank cell A12:H734, copy visible sheet and copy it in new sheet. I got stuck to find nonblank cell and next nonblank cell. I will be greatfull for your help.
Hi jpbisani,
try below code and find attached sample file
change as per your suit
Please Login or Register to view this content.
Regards,
MohanS
"Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi
You can simply say thanks by clicking "*Add Reputation" icon
It is filtering blank cell where as i need non blank cell. Sorry for trouble
Hi
replcace only this portion
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks