Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mixture error
I am trying to send an array and a variable of the type Range between two
subs (it works fine without the array) but I get type error in ByVal reference. I dont get it. Code: Private Sub hittaRubriker(varWorksheetInfoArray As Variant) Dim rng1 As Range Set rng1 = Worksheets(varWorksheetInfoArray(0)).Cells.Find_(v arWorksheetInfoArray(1), LookIn:=xlValues) Call chartMaker(varWorksheetInfoArray, rng1) ........ Private Sub chartMaker(varWorksheetInfoArray As Variant, rng1 As Range) Please please help me with this!!!! I would be most greatful! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - stop automatically changing mixture of uppercase and lowercase to propercase | Excel Worksheet Functions | |||
Currency & Accounting Format Mixture | Excel Discussion (Misc queries) | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Data Validation - mixture of options | Excel Discussion (Misc queries) | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |