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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: LouBalleweg
- Order by date
-
Entering Excel formulas from VB?
Hi frosty7700, It may be that your problem is not in your code but the way you have Excel set up. Click on "Tools", "Options", "View" and see if the "Formulas" check-box is checked. If it is, Excel will display the formula in a cell instead of the result...- LouBalleweg
- Post #12
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Error Code 9: Subscript out of Range
Thanks for the response John. My columns start with 1. Here is a copy of the two subs that have to do with the error. The error occurs in the second sub as noted in remark. Sub GetNvcLbr() Application.ScreenUpdating = False vNvcNmbr =...- LouBalleweg
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Error Code 9: Subscript out of Range
I get the subject error when the following line executes. [With Workbooks(sWorkBookName).Sheets(sSheetName).Columns (1)] The Workbook has already been opened. I have confirmed the values of the string variables sWorkBookName and sSheetName for spelling and syntax errors. This same line of code...- LouBalleweg
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
