↓ Skip to Main Content
Useful code Programming with VBA, C# and Python

Main Navigation

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About
Useful code Programming with VBA, C# and Python

Off Canvas Menu

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About
Home › Posts tagged Excel › Page 6

Tag: Excel

Excel – Get Top Row of a Multi Row / Mult Column Range
Else - Just Tricks, VBA \ Excel

Excel – Get Top Row of a Multi Row / Mult Column Range

Vitosh Aug 16, 2018 Tagged with Excel, get first column, get first row, vlookup multiple range

=VLOOKUP and =INDEX(MATCH(),MATCH()) are well known formulas, if you need to get some value corresponding to another …

Excel – Get Top Row of a Multi Row / Mult Column Range Read more →

VBA – Fill Numbers in a Given Range
VBA \ Excel

VBA – Fill Numbers in a Given Range

Vitosh Jul 29, 2018 Tagged with Excel, matrix, range, VBA

So, the idea is the following –  imagine that you have an NxN range, which should …

VBA – Fill Numbers in a Given Range Read more →

Format and Color Text in Excel Cell with VBA
Else - Just Tricks, VBA \ Excel

Format and Color Text in Excel Cell with VBA

Vitosh Jul 21, 2018 Tagged with Excel, format text in cell, VBA

Formatting a substring of a string in an Excel Cell is actually quite a challenging task. …

Format and Color Text in Excel Cell with VBA Read more →

How to Change Tab Color in Excel with VBA
VBA \ Excel

How to Change Tab Color in Excel with VBA

Vitosh Jul 15, 2018 Tagged with Excel, Multiple Tabs color, VBA

Changing tab color of Excel is somehow useful. With VBA, it is easily programmed, as far …

How to Change Tab Color in Excel with VBA Read more →

VBA – Select Multiple Cells in a Excel Range
VBA \ Excel

VBA – Select Multiple Cells in a Excel Range

Vitosh Jun 9, 2018 Tagged with Excel, Select Multiple Cells, VBA

Selecting multiple cells in Excel through VBA may be quite a difficult task. Although, using Select is …

VBA – Select Multiple Cells in a Excel Range Read more →

VBA – Simulation of Rolling Dices
VBA \ Excel

VBA – Simulation of Rolling Dices

Vitosh Jun 2, 2018 Tagged with dice, Excel, random, simulator, VBA

Excel and VBA are a powerful tool for simulation. The idea is to simulate dice throwing …

VBA – Simulation of Rolling Dices Read more →

VBA – Hide the Named Ranges in Excel
VBA \ Excel

VBA – Hide the Named Ranges in Excel

Vitosh May 18, 2018 Tagged with Excel, hide named range, VBA, visiblilty named range

Named ranges are really nice parts of Excel – you just give a name to the …

VBA – Hide the Named Ranges in Excel Read more →

VBA – Markov Chain with Excel example
VBA \ Excel

VBA – Markov Chain with Excel example

Vitosh May 14, 2018 Tagged with Excel, Markov, Markov Model, Markov Probability, Transition Probability Matrix, VBA

Markov model is a a stochastic model describing a sequence of possible events in which the …

VBA – Markov Chain with Excel example Read more →

VBA – How to Change Merged cell in Excel with Events
VBA \ Excel

VBA – How to Change Merged cell in Excel with Events

Vitosh May 5, 2018 Tagged with change cell values of merged cells, event, Excel, VBA

The worksheet events which are built within VBA are quite useful. One may build them quite …

VBA – How to Change Merged cell in Excel with Events Read more →

.Net – Reading Excel file in C# and transferring it to a matrix
C Sharp Tricks

.Net – Reading Excel file in C# and transferring it to a matrix

Vitosh Apr 5, 2018 Tagged with Excel, Excel range to C#, Interop.Excel, range to array, read range

There is an ERP joke, claiming that the third most popular button of an ERP system …

.Net – Reading Excel file in C# and transferring it to a matrix Read more →

Posts pagination

Previous 1 … 4 5 6 7 8 … 10 Next

Copyright © 2026 VitoshAcademy