Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
global variables for function arguments and return value in VB scripts
In order to use the Dictionary object, you need to reference the Microsoft Scripting Runtime, scrrun.dll. But, if you're going to distribute the application to other users, you need to tread carefully. The reason the dll is called "scripting" runtime is because it was designed to provide file...- nhebb
- Post #3
- Forum: Microsoft Visual Basic
-
Looping through a range of cells, but ignoring hidden cells
The Hidden property applies to entire rows and columns, so you might try: Dim c As Range For Each c In Range("C3:K" & rowLimit).Cells If (Not c.EntireColumn.Hidden) And (Not c.EntireRow.Hidden) Then If IsEmpty(c.Value) Then ' Perform action End If End If...- nhebb
- Post #3
- Forum: Microsoft VBA - Visual Basic for Applications
-
how to get from row,col to cell coordinate?
This is one of those annoyances that I ended up writing a function for. I always figured there should be a built-in way to get the alpha reference for the column, but I never could find one. Anyway, here's the function I wrote: Public Function GetColumnAlpha(ByRef cell As Range) As String...- nhebb
- Post #5
- Forum: -Engineering spreadsheets
-
Breaking Text Files
+1 for Peter's suggestions. You might try something like the following: Sub Breaking() Dim sLine As String Open "C:\Output.txt" For Output As #0 Open "C:\ND.txt" For Input As #1 Do While Not EOF(1) Line Input #1, sLine If (UCase$(Left$(sLine, 2)) =...- nhebb
- Post #10
- Forum: Microsoft Visual Basic
-
Document source code with flowcharts automatically.
The best way to tell is to just download the free trial, test it out, and but it if you like it. I develop a flowcharting tool (not code to flowchart, though), so I've seen it listed on the same download sites I list mine on. The product seems legit. Also many of the software download sites...- nhebb
- Post #2
- Forum: Microsoft Visual Basic
-
Concatenation of text strings
A more advanced solution would be to open up the macro editor, right-click on the Personal.xls VBA project and select Insert > Module. Rename the module if you like. Then, add the following code to the module: Public Sub AppendTextToRange() Dim rng As Range Dim c As Range Dim txt...- nhebb
- Post #4
- Forum: -Engineering spreadsheets
