displaying

I've got a bunch of formulas displaying as text, instead of showing the value of the formula- "Show Formulas" is NOT turned on! I know the fix for a single cell is to click into the cell and hit the "Enter" key. is there a fix for an entire column, or range of cells? thx!

Hi guys, Using the code below works perfectly for displaying the time how I need it to be displayed in my Listbox, but how can this be converted to be displayed in the same way as a label value? AddItem "Sunday" .List(0, 1) = Format(ws.Cells(SelectedRow, 41).Value, "h:mm AM/PM") 'Sunday...

Hi Any ideas How to prevent the Path displaying of the reference of particular sheets in formual of a cell The following was the original when coding With ws .Range("CP" & curRow).Formula=SUMIFS('Sheet7'!S:S,'Sheet7'!A:A,Sheet5!A:A,'Sheet7'!K:K,Sheet5!$CP$1) End with when the Worksheet of...

Good afternoon all, Is it possible to display a chart/pie chart in a User form?

Hi All. Can anyone see anything obvious why the loop part of this code if not looping. Its doing everything it should except its just displaying 1 rather than 1 to 13 (TMs). Sub tagteamallocate() If Sheets("Calculations").Range("AX18") > 0 Then MsgBox "There are unrecognised room types...

I have two columns one with heights (i.e. 6'6", 6'7" etc) and one with weights say column I and J. In another cell C2 I would like to be able to enter a height, while still displaying height, yet for a calculation use the corresponding weight.

<tbody> =SUMPRODUCT((YTD_GOOG_2019_CyberSource!$A$5:$A$500='Monthly Recons-Google'!C$4)*((YTD_GOOG_2019_CyberSource!$M$5:$M$500="Settlement")+(YTD_GOOG_2019_CyberSource!$M$5:$M$500="Card Credit"))*(YTD_GOOG_2019_CyberSource!$I$5:$I$500)) </tbody>

Hi I'm trying to write some code that will firstly, open a specific worksheet, then display a userform.. Anything i have tried so far displays the user form before opening the worksheet. the code i am using is below. Is there something simple i'm missing that would delay the displaying of the...

I have a button that deletes a row at a time but when it gets down to nothing left, as in, nothing in the last row, what do I need to add to this code to make it stop displaying an error of "no cells found" when it is trying to delete the last row and it has nothing in it. How do I stop that...

I've made a workbook in Excel (obviously) on my Mac, saved as a xls document and emailed it as an attachment. When it is opened on a windows pc (Excel 2007) it isn't displaying or functioning correctly even with macros enabled. For example I have in cell drop-down menus which aren't...

Answered

Hi: How can I force Excel pivot table to show dates as m/d/yyyhyyy instead of month? For example, if have several 9/30/2017 in column A, pivot table is displaying them as Sep Could you help please? Regards Sean

Hi All, I'm looking for assistance with a modelling question that I've hit a few times in Powerpivot: displaying only *related* row labels from the many side of the relationship, as a subordinate row label to the "one" side records. I have an example model screengrabbed that I think makes the...

Is there anyway of having code to hide this please?

I have an Excel file with a tab of PowerView map. I upload this file to OneDrive and view the file on Excel online (office.com) The pivot Table etc are displaying, but the PowerView Map is not displaying. Please help. How to enable displaying on Office.com Thanks

I have a formula that works great: =VLOOKUP($D4,CHOOSE({2,1},$B$3:$B$25,$O$3:$O$25),2,0) What I am wondering now is if the value in O3:O25 is = 0, how can I keep the cell from displaying the information from B3:B25? I tried an IF but couldn't get it to work as it put a '0' in the cell.

I have this formula =M123/H123 in a cell. When the value in one of those cells is 0 I get #VALUE ! displaying. I need that display to go away. How can I make that disappear? Thank you

I need to test multiple conditions for a selected cell. The first if statement is doing the proper calculation. The next two are adding up instead of just displaying the value in the cell. Any suggestions? If statements are below...

Good evening, Is it possible for VBA to create a personalised greeting, based on the user settings of a PC? For example, if 'user A' opens a workbook stored on a shared drive, the worksheet responds by displaying "Hello user A" in cell A1. If 'user B' opens the same workbook at a later point in...

If a Cell has 0.0000034 I want it to display 0.0034 or .0034 Thanks