Home
Solved
- javascript
- c++
- java
- git
- php
- arrays
- html
- python
- jquery
- mysql
- .net
- json
- ajax

worksheet

[Solved] I’m trying to add a count to the number of searches found in my code

November 13, 2022 by Kirat

With the current code you have you don’t even need to use a counter. Instead you can load FoundAt into an array and then use the Ubound to get the total count. Note you have to add 1 since the array is 0 based. Add these lines before your final Msgbox Dim iCount() as String … Read more

Categories Solved Tags counter, excel, vba, worksheet

[Solved] excel vba compare & copy worksheets from 2 excel files

November 9, 2022 by Kirat

First of all you need to loop through all your worksheets for both, open the 2 workbooks, and loop through both, then you can select them, compare if their name exists in the other worksheet, if not, you add it, otherwise, you copy the content from one to the other one and at the end … Read more

Categories Solved Tags excel, vba, worksheet

Search for: