Forum

Thanks a lot Phil for your help this has worked brilliantly.

Hi Phil, That seems to work brilliantly. What I have forgot to add in on my original post was that column D also has to have a date in it otherw...

Hi Philip, Thanks for your reply. In answer to your questions:- For every row in the pivot that does not contain a Yes in column E I nee...

Hi Philip, For the purposes of testing the keyboard can be used instead of a scanner. When you double click on a cell it thinks there ha...

My apologies I should have said that the password for unprotecting is summerscales. It's the same password for the vba properties

Thanks Purfleet for your reply and pointing out the obvious to me that I had stupidly missed. I didn't have 'Inventory Booked In' unprotected. Onc...

Thanks for your reply Purfleet. I have the code working correctly as a standalone bit of code. My problem is I need it to run within my code that's...

Text to Columns can only be applied to one column at a time. However, you can store all the columns you want to apply it to in an array and loop throu...

My apologises there doesn't seem to be the workbook attached

Hi Sunny, I tried running the above code on a test sheet. When I have used it in my workbook I am having problems with it. I have attach...

Thank you Sunny. That works brilliantly

Hi Sunny, Thanks for your reply. I knew I had to change If Cells(r, "E") = 0 Then The bit I cannot figure out is. In worksheets ...

Hi Sunny, Your code in post #2 works brilliantly for deleting the row on the active sheet. What I am requiring is very similiar to this code. ...