Microsoft Excel

130K

Solutions

193

Articles & Videos

37K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Related Topics

  1. Microsoft Office
  2. Visual Basic Classic
  3. VB Script
  4. Microsoft Applications
  5. Spreadsheets
  6. Microsoft Access
  7. VBA
  8. Microsoft Word
  9. Programming
  10. Visual Basic.NET
Refine results

please see attached file.

it is a working tool, it fetches data from a site and put in excel. currently it uses the class that works with Internet Explorer.

is there any possibility or if anyone…

320 views
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

i have inherited a file from a colleague that uses these function arguments  INFO("memavail")  INFO("memused") INFO("totmem")
with excel 2016, these return ERROR. i googled and found that these …

29 views
Warning
This article describes a serious pitfall that can happen when deleting shapes using VBA.
028 views

Hi,

attaching file as example
i have a cell reference as B4 in sheet 2, where the number changes as per the data entering in sheet 3.

now i want help to write a code to pull the data in sheet 1…

1017 views

Good AM gowflow,

       I just tried it in a large file. It always auto refreshes every time I open the sheet "data" and it takes 30 to 50 seconds to finish refresh. Is their any alternative …

211 views

Please help! I have excel files that include thousands of data points.

One file contains case number, date of birth, age, subunit, and price.
The other contains case number, date of birth, age, …

431 views

Hello,

While trying to add additional rows to the formulas below (Example C9:C:400 or AC9:AC400) then hit enter and the formula pops up but it is not functional. I'm at a loss. ANY help would be …

613 views

Hi all.

I'm trying to figure out how to change the code below to be more dynamic because I will not know how many columns there are after column H nor how many rows there may be because it is based…

512 views

have a folder with files named

people_results (1)
people_results (2)
etc etc

want to rename to

1
2
3
etc etc

319 views

I have an excel workbook that only has a single button on it the launches the following sub routine.

(CODE)

When launched it works the first time through but then when it loops I get a Run-Time …

311 views
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hi,

I have the below code returning Run-Time Error 1004 - Unable to get the Vlookup property of worksheetfunction class error. I noticed issue happens when lookupvalue is not in lookup range. Can …

211 views

Dear Experts:

i need an VBA to create list of Worksheets based on  cell "A31" from Sheet 120 and cell "A29" from Sheet 121. If "Reporting Population: Non-Charged Off Accounts" exist in worksheet …

1425 views

Hi there,
Was wondering if anyone can help me out here...
I 'inherited' a spreadsheet to fix...apparently in Excel, a row 'appears' to be missing some data.

If you look at the highlighted area, …

814 views

Hi all.

At first I used the following code
(CODE)

to replace any blank cells with 0 but then I realized that some cells in columns A-G are supposed to be blank and therefore should not have 0.…

28 views

Experts:

I have discovered that I can easily convert my MP4 files into SWF files, and add the ActiveX control to my Excel 2016 XLSM file, but I have a couple of questions I'm hoping can be answered…

325 views

While I know this is a simple IF statement, I am learning UDFs so I wanted to see how it is done in this case.

In the attached worksheet, this is the formula for the first row:

522 views

Hi all.

I'd like to custom format to mmm-yy the column headers starting with H1 and going on to I1, J1, K1, L1 etc. as long as the cells in each column header have data.

I don't know how many …

68 views

Hi, Does anyone have the code to loop through a folder and combine all the spreadsheets present into worksheets on a master spreadsheet?

513 views

I'm trying to:

a) tabulate in a new worksheet all of the named ranges in a given worksheet (I will later try this for a workbook with multiple sheets)
b) list beside the named range its …

1912 views
MS Dynamics Made Instantly Simpler
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Thank you for looking at my question,

I have two columns in a larger worksheet Date and Confirmed. Date contains date values in the format dd-mm-yyyy and Confirmed contains the word "Yes" where …

515 views

Hi expert,

         Is it possible to assign multiple macro in one command button? I want to refresh all sheets with just one click of a button and in every sheet has a different macros. This …

924 views

Hello,

I am working with a bank and they say the day count between Dec 20, 2016 to up to but excluding June 20, 2017 is 182 days.  

If I enter:
Start Date = Dec 20, 2016
End Date = June, …

1225 views

Hi all.

I get the following error when I click a form button in the Excel file when the Excel file is in a shared network folder, but if the Excel file is on my desktop I don't get the error. Also,…

825 views

Greetings!
I have a column of numbers H4:H493

I would like to create a query in cell below H493 which does the following:
return a count of all cells containing a value range of 0-19

Next, I …

818 views

i have this tool and now i get this mismatch error in (CODE)

317 views
Show more content
201506-LO-Top-001

Microsoft Excel

130K

Solutions

193

Articles & Videos

37K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Related Topics

  1. Microsoft Office
  2. Visual Basic Classic
  3. VB Script
  4. Microsoft Applications
  5. Spreadsheets
  6. Microsoft Access