↓ 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 7

Tag: Excel

VBA – Delete / Remove rows from a specific worksheet in Excel
VBA \ Excel

VBA – Delete / Remove rows from a specific worksheet in Excel

Vitosh Apr 2, 2018 Tagged with delete rows, Excel, remove, remove lines, VBA

Imagine one of the most trivial tasks in Excel – remove rows from Excel, for which …

VBA – Delete / Remove rows from a specific worksheet in Excel Read more →

VBA – Formulas in Excel LocalFormula
VBA \ Excel

VBA – Formulas in Excel LocalFormula

Vitosh Mar 19, 2018 Tagged with Excel, Formula, LocalFormula, runtime error 1004, VBA

The formulas in Excel, used through VBA are not easy. You need to write a string …

VBA – Formulas in Excel LocalFormula Read more →

VBA – Difference between Trim, VBA.Trim, =Trim() and WorksheetFunction.Trim
VBA \ Excel

VBA – Difference between Trim, VBA.Trim, =Trim() and WorksheetFunction.Trim

Vitosh Mar 11, 2018 Tagged with difference, Excel, trim, VBA, worksheetfunction.trim

Trimming is a function, that reduces spaces. There are at least 4 ways to Trim a …

VBA – Difference between Trim, VBA.Trim, =Trim() and WorksheetFunction.Trim Read more →

C# – Looking for a value in Excel with C# & VisualStudio
C Sharp Tricks

C# – Looking for a value in Excel with C# & VisualStudio

Vitosh Mar 3, 2018 Tagged with C#, Excel, find, visual studio

Using Visual Studio and Excel is actually quite fun – the Visual Studio advanced environment provides …

C# – Looking for a value in Excel with C# & VisualStudio Read more →

VBA – Why Range.Find() sometimes mistakes January with November and Febrary with December?
VBA \ Excel

VBA – Why Range.Find() sometimes mistakes January with November and Febrary with December?

Vitosh Feb 24, 2018 Tagged with Excel, excel vba, find, search, VBA

After writing that the built-in Find() function in VBA does not return the first value by …

VBA – Why Range.Find() sometimes mistakes January with November and Febrary with December? Read more →

VBA – ArrayList class – a helper to sort arrays in VBA
VBA \ Excel

VBA – ArrayList class – a helper to sort arrays in VBA

Vitosh Feb 12, 2018 Tagged with arraylist, Excel, sort, sort array, VBA

If you are coding professionally in VBA, most probably you are using arrays every now and …

VBA – ArrayList class – a helper to sort arrays in VBA Read more →

The dates in Excel, VBA and SQL Server
VBA \ Excel

The dates in Excel, VBA and SQL Server

Vitosh Jan 29, 2018 Tagged with dates problem, Excel, SQL Server, VBA

There is a lot over the Internet, written for the dates in Excel, VBA and SQL …

The dates in Excel, VBA and SQL Server Read more →

VBA – RegEx in Excel – Part 2
VBA \ Excel

VBA – RegEx in Excel – Part 2

Vitosh Dec 5, 2017 Tagged with Excel, regex, remove characters with string vba, strip a string, VBA

After the first part about RegEx in Excel lately I had to do something else with RegEx. …

VBA – RegEx in Excel – Part 2 Read more →

VBA Excel – How to convert range to array easily
VBA \ Excel

VBA Excel – How to convert range to array easily

Vitosh Oct 27, 2017 Tagged with array, Excel, range, transpose, VBA

Converting a range to array makes a lot of sense in VBA, when some operations should …

VBA Excel – How to convert range to array easily Read more →

VBA – RegEx in Excel
VBA \ Excel

VBA – RegEx in Excel

Vitosh Oct 20, 2017 Tagged with email verification, Excel, regex, VBA

There is a well-known joke in the IT world – if you have a problem and …

VBA – RegEx in Excel Read more →

Posts pagination

Previous 1 … 5 6 7 8 9 10 Next

Copyright © 2026 VitoshAcademy