Search results for query: *

I have data with serial numbers that are up to 20 digits in length. They are alpha numeric but sometimes only happen to have numbers. When that is the case Excel converts them to Exponential numerics as soon as it sees them. The only way I can restore the text version is to manually insert an...

It seems as though for the last few years or so, whenever Excel gets bogged down in something it is impossible to cancel out of it by hitting escape as the screen says to do. Similar when a popup comes up warning you that it cannot complete an operation with the available memory and a cancel...

I have this simple formula form in many cells: =IF(AND($B5=1,$A6=$A5),E6,"") When there is nothing in cell E6 (in this case), it returns a zero instead of blank. Zero is also a valid possibility for cell E6, so I can't just change all zero returns to blanks. I can get around by using this...

I have Office 365 but I also still have Office 2010 installed. I don't like the way 365 does certain things and so I want to use 2010 as my default app in Excel. I was able to set this up without any trouble my other computer but on my new computer, even though it shows that there are two Excel...

When I create line graphs, sometimes it sets them up in such a way that the horizontal axis labels are specified in the same dialog box as the series name and the vertical data points, like the first screen shot in the attached document. Other times it only has the series name and the series...

I am making various reports that are basically the same but with different specifics. So for the first on I created a nice Excel sheet in which a I can carry out all my manipulations and I have various ranges of that sheet linked to charts in the Word document. Now I want to be able to make a...

My 2nd issue today is that I can’t figure out what is going on with the trend line equations. I have this particular chart to which I have fit a 4th order polynomial trend line. It looks great – just what I would expect. However when I plug the x values into the equation it has provided, I do...

The first issue I have is that when I copy an entire worksheet which includes multiple charts, all of the charts keep the reference to the origin sheet in their data definitions. This makes me blue because I just want to be able to paste new data into the new sheets and be done! But instead I...

Is there a way in excel to find the intersection of two line plots and create a line that goes from that point to the x and/or y-axis.

So, this is hands down the craziest thing a computer program has done to me to date. I have a very complicated (lots of command buttons, macros, sheets, complex equations) spreadsheet that is used as a template for specific cases. It's been working fine for a long time. Suddenly the following...

I have a workbook that gives me the spiel about it having external links and asking if I want to update them. I in fact want them gone as they should only point to places within the workbook. So, I searched for all occurrences of ".xl" in the formulas. I found some and fixed them up and now the...

I created this bit of code using the "Record Macros" feature to get the syntax for the paste properties right and it worked as expected when I was recording. But when I run the macro it takes the format and formulas. Is there a way to make it behave properly? Sheets("Raw Paste").Select...

I am using the Solver feature of Excel in some workbooks that I have. At some point a small dialog box pops up requesting the Solver Password. It doesn't seem to prevent me from doing anything, but it won't go away. In fact I can close all my workbooks and the dialog box remains. Nothing will...

What is the syntax for testing for blank cells within a select statement. It seems to consider them identical to 0, and this will not always be the case. If the cell contains zero it is valid data and must be viewed differently than is there is nothing there. If I use Case Null: it skips right...

I have a number of Excel files that are all of the same general design with several sheets each. I have added a number of formulas to one of them. These formulas reference cells within other sheets within that workbook. I don't want to start over with all of the other workbooks so of course I...

I have numbers in this format: 5.24 37.128 124.7 i.e. various decimal places and magnitudes, but always less than 1000. I want to convert them to strings that are 5 characters long that include leading zeroes and retain two decimals of accuracy. So the above numbers would be: 00524 03713 12470...

Part of the code that I want to execute when a particular command button is clicked upon, is to move to the first record of the form. This is a small form in which all 14 records of the small dataset in 'continuous' mode. The number of records never changes, as they are just settings to be used...

Part of the code that I want to execute when a particular command button is clicked upon, is to move to the first record of the form. This is a small form in which all 14 records of the small dataset in 'continuous' mode. The number of records never changes, as they are just settings to be used...

I have a macro which crashes with the error statement “Application Defined or Object Defined” error '1004" after a simple Range("A2").Select statement. In desperation I tried: With Sheets("MT 2010") .Range("A2").Select End With with the same result. I've tried putting that section...

I often have vba code that runs action queries and I want the warnings temporarily suppressed during their execution, so pretty much the standard usage for the SetWarnings method. So at the beginning I put in: DoCmd.SetWarnings (WarningsOff) And at the end I put in DoCmd.SetWarnings...