By | November 1st, 2017|Categories: Excel Macro, Excel Tips|Tags: , , |

Dear Friends, In this article, I am going to share a quick tip related to Excel. It was asked by one of my colleague recently. How to show or hide Group Outline Symbol in Excel Workbook when you group any row or column. Here I will show you both the [...]

By | October 24th, 2017|Categories: Excel Macro, Excel Macro Basics|Tags: , |

Dear Friends, Previously I have written about how to protect and un-protect a Sheet in a Workbook. In this article, I am going to cover all about protecting and unprotecting a workbook. This is going to be a short and simple article, yet informative and useful for your day to [...]

By | October 12th, 2017|Categories: Excel Tools, User Defined Function|Tags: , |

Dear Friends, In one of my previous article, I explained you about Netherlands BSN Number validation. This used to be called as SoFi nummer (Short form of dutch word - Sociaalfiscaal nummer) as well in the Past. Here in this article, I am sharing VBA code and a FREE downloadable [...]

By | October 8th, 2017|Categories: Excel Macro, Excel Tools|Tags: , , |

Dear Friends, As you have learnt about interacting with Text files through Excel VBA, it is time to see the usage of those methods you learnt. One usage, you have already seen here, in how to export excel data in CSV format. In this article, I am going to teach [...]

By | September 2nd, 2017|Categories: Excel Macro, Excel Macro Tutorial, Excel Tips|Tags: , , |

In this article, I am going to teach you 4 VBA Methods of - how to export data from Excel Range to a CSV file format using Excel VBA.

By | August 28th, 2017|Categories: Excel Macro, Excel Macro Tutorial|Tags: , , , |

Dear Friends, I am back with the second part of the tutorial- VBA Guide to Interact with Text Files – Part – 1 of 2. This is the final part of this tutorial. In previous article, mainly we learn about How to Open a Text File and How to [...]

Join The 100,000+ Satisfied Avada Users!