Featured
- Get link
- X
- Other Apps
excel CountA Giving wrong output in VBA Stack Overflow
excel CountA Giving wrong output in VBA Stack Overflow. As a best practice in vba, you should never use the select method. This will loop through all cells in a given range that you define (range to search) and add dashes at the cell below using the offset() method.

This will loop through all cells in a given range that you define (range to search) and add dashes at the cell below using the offset() method. Sub adddashes() dim srchrng as range, cel as range set srchrng = range(range to search) for each cel in srchrng if instr(1, cel.value, total) > 0 then. As a best practice in vba, you should never use the select method.
As A Best Practice In Vba, You Should Never Use The Select Method.
This will loop through all cells in a given range that you define (range to search) and add dashes at the cell below using the offset() method. Sub adddashes() dim srchrng as range, cel as range set srchrng = range(range to search) for each cel in srchrng if instr(1, cel.value, total) > 0 then.
Comments
Post a Comment