fix

Hi, i have created a vlookup and did a grafh. when i clock on Categories in reverse order the data shows worng, how can i fix this problem? as you can see the First and the last as changed the numbers.

Hi everyone, I had an issue with a macro in my workbook, which is now resolved. However, I can not get the margins, headers and overall formatting of my document back to the way it was. I've re-created it, tried it from another version of excel, even a different pc but the margins are just not...

=OFFSET(I$3,(MATCH(LARGE($B:$B,(ROW()-2)),$B:$B,0)-3),0)+ROW()/10000 I am using this formula, and it works as long as cell I3 does not equal #NA . Is there a way to fix this formula so when #NA is in cell I3, it returns blank instead of #NA ?

Hello, İn attached file there are numbers in A column. I need to delete numbers after ''.'' . But some rows have . and 2 number some have . and 1 number and also some dont have number. How can I fix it...

Dear, I see a run time error pop-up when I open my excel file. I don't know how to attach the screen shot to this thread... -2147024809 (80070057) run time error Can anybody help me to understand this and let me know how to fix it?

Hi Excel peoples I'm using a Listbox which contains three selectable items - the idea being that people can select any number/combination of the three as they see fit. It works fine but the linked cell reports '0' when more than 1 item on the listbox is selected. I've read around and the only...

Need help with the following formula: =INDEX($U$3:$U$10,MATCH(B3,$T$3:$T$10,0)) When there's not entry in U3 it returns an error (#N/A). Is there a way to fix this?

https://www.mrexcel.com/forum/excel-questions/1046359-windows-dpi-settings-affecting-print.html needs a title fix

I'm trying to hide or turn off horizontal scroll bars in a listbox. It's a single column listbox holding one chrW(9660) and only needs to be about 20 wide. But the width must be 71 or more to not have a scroll bar. Any fix for this ? Thanks.

Hi. I'm having issues with a formula and I can't figure out how to fix it. I have the formula =IF(AND(R$2>=$C4,R$2<=$D4),1,0) in R4. What I would like to happen is to enter a start date and end date in Columns C & D and have the applicable columns to follow highlight using conditional...

I'm in dire need of some help here. I'm getting the "Excel Ran out of Resources" error. I've googled a good bit, and it seems to have something to do with this formula. =MAX(IF(INDIRECT("'"&C2&"'!D:D")=Summaries!C2,INDIRECT("'"&C2&"'!I:I"))) Right now, I have about 20 of these formulas on one...

Before talking about question, i want to tell you that i am from South korea and there isn't enough information in southkorea about excel VBA. so i came here. i have studied literacture subjects so i maybe not good at understanding the "method" of vba. i just try, and fix, and try, and fix what...

Hello All, I have a field in a pivot table that is troubling me. I went to pivot table options and have it set to show 0.00 if there is an error. It is doing this fine, but it places it in the cell generically left-aligned and does not match the accounting format that the rest of the values in...

The following code does not run across all of my worksheets. It seems to just run the same code on the first tab multiple times. Can someone help me fix this? My best guess is that that the ActiveCell member is causing this issue, but I do not know how to fix this. Sub...

Hi all, If I save my workbook during my session the below code works perfectly, refreshing the query quietly in the background. The problem I am facing is that when I am prompted to save on close the macro will start running (I can see that it starts because of the "retrieving data" status...

I am sure this is a stupid simple fix but I am drawing a complete blank.... Every morning I have to fix a 30K line report and there has to be an easy way around it. Thank you as always!

Hi to all I have a simple question. i have two sheets with 2 tables, where table in sheet 2 should feed data to table in sheet 1. but that doens't happen. How can i fix this. best regards Akasha Walker

Hi I want to fill the whole worksheet with "hello" or with a number like 1 I wrote the code below. It is only working if x.Value = "" (clearing the sheet) but when I type x.Value = "hello" or x.Value= 1 I got error message. Any idea how to fix that. Thank +++++++++++++++ Private Sub...

Hello, I have a little problem. I have a large statistic table in one WB and in a different WB references to the first one. When I open my second WB i see #ARG ! in every cell, but when I open both the values are displaying properly. Can I somehow fix it so that values would be correct if...

i have uploaded a copy of VBHTMLMaker it used to work in my excel 2010 32 bit. i have upgraded to 64 bit of 2016 version Excel. and it does not work. it gives errors and i do not have the passwod to debug and see how to fix it. anyone has any updated working copy? or anyone can help me fix...