Dear friends
I am working on excel I need one help. In my excel I am using lot of sheets (that means I entering data and daily creating new sheet. name is on that date).using more formula in that sheets so I will protected the sheet but I not able to delete row and columns wiled in locked. is there any macro to delete unwanted row is there any other option?
Thanks
i attachedOriginally Posted by vba_php
Please Login or Register to view this content.
Please Login or Register to view this content.
Dear vba_php
you select Range("a15").EntireRow.Delete Shift:=xlUp. but i enter after 16 and 17 row i wand delete blank rows only please find the attachment and one more thing A to Q only
delete
Last edited by sudbhavani; 12-03-2020 at 07:48 AM.
you posted a new book with no new data to run a test on. your description is also not clear.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks