Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub RenameColumns(SheetName As String, ParamArray arrColumns() As Variant)
- Dim element As Variant
- Dim Counter As Integer
- Counter = 8
- For Each element In arrColumns
- If Counter >= 16 Then Exit For
- 'Error Type Mismatch occurs in the below line. CsStr(element) = <Type Mismatch >
- Range(GetColumnAddress(CStr(element), SheetName)).Value = arrColumns(Counter) 'Here I am getting error Type Mismatch
- Counter = Counter + 1
- Next element
- End Sub
- Function GetColumnAddress(ColumnName As String, SheetName As String)
- Dim strSearch As String
- Dim aCell As Range
- Dim sheet As Worksheet
- Set sheet = Sheets(SheetName)
- strSearch = ColumnName
- Set aCell = sheet.Rows(1).Find(What:=strSearch, LookIn:=xlValues, _
- LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
- MatchCase:=False, SearchFormat:=False)
- If Not aCell Is Nothing Then
- GetColumnAddress = aCell.Address
- Else
- GetColumnAddress = "$A$1" 'Error!
- End If
- End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement