I've been trying to record a macro that will search a column (Col B in my case) for any cells containing the word "day", select these cells and delete them (shift cells to the left).
Whenever I try and record this action it's only recording the cell selection, not the find and select and delete/shift.
Any ideas or solutions?
Last edited by BPSJACK; 07-24-2012 at 07:00 AM.
Here you go
Please Login or Register to view this content.
Hi,
I believe you should use a loop. Can you please post an example spreadshset and I will see what I can do
Example attached:
Please Login or Register to view this content.
Gives me 'Run time error 1004':Delete method of range class failed' when I try it on my spreadsheet.
Hi BPSJACK, try it
Please Login or Register to view this content.
Works like a charm thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks