basics

  1. F

    Suggestions on where to learn the basics

    Does anyone have suggestions on where to go back to the basics of learning VBA? I've been self-taught over the past six years by reverse engineering results from the macro recorder and Google searches. I've always felt like I skipped the basics and never learned anything about the core concepts...
  2. H

    Basics to start

    I have considered Excel, Business Intelligence as career. I want to learn basics but don't know where to start. Can anyone please guide what should be the route. Power Pivot, Power Query or BI. Shall be thankful to all of you
  3. I

    Lottery Optimizer 6/45 using elimination of combinations

    Hey all, I'm in charge of a syndicate group and we're looking for an excel macro/program that produces the an optimized set of numbers whose combinations have not been or less repeated by previous combinations. Lottery Basics: 6 numbers from 45. Order does not matter. Can play 7 to 20...
  4. B

    [VBA] Overview comments

    Hi guys, I found the following vba code online which creates an additional sheet with all comments in a table: Sub ShowCommentsAllSheets() Dim commrange As Range Dim rng As Range Dim ws As Worksheet Dim newWs As Worksheet Set newWs = Application.Worksheets.Add newWs.Range("A1").Resize(1...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top