Search results

Thank you Vletm, I will show these to my boss and see what he thinks.

I went ahead and deleted the line to test, as well as a few other lines you said were not needed, and it worked beautifully. It is a little slow, but worked with the output that I was required to give to our fabricators. Thank you so much for the help, I owe you a beer. I'm going to test it on...

That is exactly what I'm looking for. So can I delete the stop line as well, so that it goes straight through without hitting F5? You are a miracle worker.

P45 Do you know how I can get rid of that error, or stop it from failing? As far as I know that line doesn't serve a purpose.

Ok ,thank you for all of your help. I will keep searching, hopefully I will figure something out.

I apologize if I seem stubborn or like I'm not listening while you two are trying to do your best to help, it is not my intent. I am self taught when it comes to excel and there is a lot I am still learning, and even more that I don't know. I was given a task by my boss to make this work and in...

Not all of the end users will have computers, the fabricators work strictly off of a paper copy. So they never see the Excel. Earlier you mentioned just coding out the error line and it will work, how do I do that? As I said, still a lot I don't know about excel.

As I look at it more, I think the "Selection.ShowDetail = False" line is being created when I run the Macro.

Maybe if I explain the steps I have to take and the end delivery it would help? We have plumbing software that we model our piping and hangers in in 3D. After we model and coordinate our hangers for hanging the plumbing and duct work, we export a data file for the project, into Excel. That...

Yes sir, sadly, all of the sheets are needed. The end users don't know how to use filters, or excel, and many refuse to learn anything technology based. So I have to give it to them as simplified as possible. It means more headache and work for me, but in the end, it is my job to make it to...

Not sure I did it correctly, but here is the .bas file exported out of Excel for the macro.

I have to make those sheets in order to separate everything out by size. I have the overall data sheet, then I have a sheet that gives the hanger count for purchase. All of the rest of the sheets are to separate those hangers by rod size, so the products can be prefabricated at the lengths shown...

It's labeled as - run-time-error-1004-unable-to-set-the-showdetail-property-of-range-class

Thanks for the response Vletm, I posted the question last Wednesday on here, with the text file and my excel files.

I have a similar error 1004, but it is with filtering in a pivot table. Any idea how I can fix it? I've been trying for over a week. I've tried posting the code on here, but it says it contains too many characters to upload. Here is screenshot, I can upload a .txt file as well.

I have tried to google the error code multiple times, but it sounds like it's not always the same cause or the same resolution. Any help would be appreciated. Please let me know if there is any more information needed. I tried to embed the code here but it says there are too many characters, so...

Hi, I'm new to the group and have hit a wall writing a macro. I am trying to create a Bill of Material Macro for work, breaking the BOM down by size and separating everything into different sheet tabs. It all seems to work fine until it tries to filter and sort my second pivot table. I attached...