microsoft

Hi there Newby here so not sure how much/little info to post, moderate excel skills, slowly going mad over a project I really please need help with! I have searched this forum and Google with no luck. Heres my problem - I have a XLS with 20,000+ rows and I need to check if words match a table...

Hello, I'm getting a self generated Microsoft Excel popup message: Is there any way to suppress this self generated Microsoft Excel pop-up message? Please let me know. Thank you! Pinaceous

I am using the following code to automate goal seek with an assigned button. Each time I tried to run it I get an error with big red X with 400. Any idea how to fix this? Sub GoalSeek1_Click() Range("E22").GoalSeek Goal:=Range("6000").Value, ChangingCell:=Range("D6") End Sub

Hi, Expert I am new in a Excel. I went to get you expert solution for creating a VBA. I Can not Find "Microsoft Date & Time Picker Control 6.0 I Find only Microsoft Outlook Date Control. But Do not work it. Please help.

I'm using Microsoft Excel 2010 and had a few useful add-ins like flex find installed. https://www.jkp-ads.com/officemarketplaceff-en.asp.However, I do not use these add-ins frequently. Since it seems that Microsoft excel 2010 loads, these add-ins at start-up and it significantly increases the...

I have a computer program that frequently creates new files in a given directory. I then have to open the latest file in Microsoft Excel in that directory and work on it. Whenever I do Ctrl+O and bring up the file open dialogue box, it brings up the list of files in the given directory with...

Longer time user of this site, but rarely have i needed to post a question, as I normally find the anwser, but this one has had me stuck for a couple of weeks (off and on). A wrote a rather large piece of code, which is basically a database for storing lots of information in mutliple table...

I am woking with Excel 2013, and I am trying to import all rows and columns of data from a Select Query in Access. I have 4695 rows of data within the access query and Excel is only importing 1457 rows. I'm quite confused as to how its only partially working. If I am to step into the code...

Can anyone help me with the answer to this question? when using the Microsoft query wizard what feature is used to designate the rows to include in a query? source selector data filer data validator row selector limited query I had a feeling it was row selector or source selector but I've...

When I try to save as the Microsoft Excel 2010 worksheet in HTML format, it is not visible in Google Chrome but it is visible in Internet Explorer 11. I looked at the HTML source and it seems it must be visible but perhaps there is some tag which makes it difficult for Google Chrome to display...

Hi I want to insert some pivotcharts and charts to userform in Microsoft Excel 2013 visual basic for application. Would you please help me on this ? Thank you in advance.

Hi Everyone, Not had this before but everytime i insert a formula into a sheet I get an error pop up say Microsoft visual basic for aplications X 400 any ideas whats cousing it? Thanks Tony

I open an excel workbook and receives the following error: Sorry we couldn't open: http://goldwing.shinhan.com "and a few Chinese letters".xls I press okay Then another message appear: Microsoft excel cannot access the file http://Goldwing.shinhan.com and a few Chinese letter.xls I have no...

i work with 200+ sheet on a Single Excel workbook. I need nevigation tips. Specially. Jumping on Last Sheet 1st sheet. On my Office pc i see a button to jump to first and last sheet. But not on home pc. Microsoft Professional Plus 2016

I have a problem. How to get the names of sheets from closed workbook using VBA? I can't use Power Query or Microsoft Query... Id like to use VBA. Thanks in advance.

Evening guys, Been looking at some excel training for sometime and this £20 course popped up from New Skills Academy, syllabus looks ok. it’s CPD certified in the UK, but no hint if anything from Microsoft. My question is are there any excel courses anyone would care to recommend, that are...

While it is simple formula that I could just copy down, but I am interested in user-defined formulas so how would a UDF be written for this? =f10&""&e10

I'm using Microsoft Excel 2010. It allows me to freeze the panes but it only permits either the left pane or the top pane. How do I freeze both the left-sided pane as well as the top pane? Thank you for any inputs

I had a few questions answered in this forum that helped me a great deal in working with Microsoft Excel, despite my disability. So I thought I would share my knowledge which may help people who are having any kind of disability or pain while working on a computer. (for example, people with...

Hi, I been struggling with this for awhile, I'm trying to group the last 10 records by date for each field, totals only, also if I add another date, I need it to keep a running total by last 10, I can do this in Microsoft Access using Top Select 10. Is this possible in excel or is there a link...