Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array - type mismatch
I have the following section of code which is giving me a "type
mismatch" error at: == For CapsSheets = LBound(CapsSheetarr) To UBound(CapsSheetarr) Can anyone help with this? Thanks... Dim CapsSheetarr As Variant Dim CapsSheets As Integer Dim tlcapscell As Range Dim blcapscell As Range Dim brcapscell As Range Dim capsrange As Range Set CapsSheetarr = Sheets(Array("Metro AHK Base", "Metro AHK Complete")) For CapsSheets = LBound(CapsSheetarr) To UBound(CapsSheetarr) With Worksheets("" & CapsSheetarr(CapsSheets)) .Select Set tlcapscell = .Cells(3, 2) Set blcapscell = .Cells(Rows.Count, tlcapscell.Column).End(xlUp) Set brcapscell = .Cells(blcapscell.Row, blcapscell.Column).End(xlToRight) Set capsrange = Range(tlcapscell, brcapscell) End With Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type Mismatch: array or user defined type expected | Excel Programming | |||
Type mismatch problem in array - ?? | Excel Programming | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming |