- Strength to Increase Rep
- +3
- Strength to Decrease Rep
- -0
- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
 | Hi, Try using the 'Instr' method. see [Click Here](https://msdn.microsoft.com/en-us/library/8460tsh1%28v=vs.90%29.aspx) |
 | Hi Mike, If your Excelsheet was new, every blank cell has a NULL value which will create an error. Furthermore I do not see who you tell the routine until which row it has to read. Good luck, Rene (I am a bit short in time so I can't have … |
| | To have you on the path to a solution: Make a Do While loop with your found last row! use a Counter as variable for creating your range in "Cn" and match where you are. something like: Dim MyRowCounter as Integer = 2 Do While MyRowCounter =< LngLastRow concatenate your … |
| | Re: about combobox Or you can create a few arrays and instead of using if you can also use select case (or is this vb?) |
| | Hi all, I am Rene, 45yrs from the Netherlands. I am self employed advising engineering firms with their 3D designs and support everything involving projects. To do my job i am trained in vb6, vba, lisp, pascal, vbscript, sqlserver (yes all ms), 3D design software and minor programming techniques. While …  |