I am trying to invoke a method with the following signature
CODE
order2(ByRef orderRange As Range, ByVal serverCell As String, _
ByVal extendedAttribColumn As Integer, ByVal fromOrdersPage As Boolean)
Of particular interest is the orderRange variable. I have NO IDEA what VBA wants and all my attempts have failed. I'm trying to work with code that is already written. The way the application functions now is that the user has to select a cell and then the method is called normally with:
CODE
Call OrderFunctions.order2(Selection.rows, serverCell, extAttribColumn, False)
Which is all fine and dandy but I need the method to be called WITHOUT user input. I can't for the life of me understand what exactly selection.rows is! I've played with it and played with it in another list but yahoo is being slow today and I need to knock this out. So far I have:
CODE
Dim theSelection As Range
Dim serverCell As Range
Dim extAttribColumn As String
Set theSelection = Worksheets("Conditional Orders").Range("A10")
Set serverCell = Worksheets("Conditional Orders").Range("D5:E5")
extAttribColumn = 32
Call OrderFunctions.order2(theSelection, serverCell, extAttribColumn, False)
But this just gets me a "type mismatch" error. Really helpful!
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
1 Jun, 2009 - 12:00 PM
| 
