Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't select range
The following code works until the last line:
Option Explicit Public Sub TribalInvCheck() Dim wbTribalHist As Workbook Dim wbTribalTR As Workbook Dim wsTribalTR As Worksheet Dim wsTribalHist As Worksheet Dim rTRCell As Range Dim lTRRow As Long Dim lHistRow As Long Dim rFoundID As Range Dim sTRID As String Dim rTribalHist As Range Dim lHistCol As Long Set wbTribalHist = ThisWorkbook Set wbTribalTR = ActiveWorkbook Set wsTribalTR = ActiveSheet Set wsTribalHist = wbTribalHist.Worksheets("Historical") 'Range set temporarily until I can find out how to set the range to the longest column in the range Set rTribalHist = wsTribalHist.Range("A3:Iv150") 'Application.ScreenUpdating = False If ThisWorkbook.Name = ActiveWorkbook.Name Then MsgBox "Please do not run this macro from the workbook that contains it." _ & Chr(10) & "Please select a Turnaround Report and then restart this macro." Exit Sub End If Set rTRCell = wsTribalTR.Range("A3") sTRID = rTRCell.Value Set rFoundID = rTribalHist.Find(sTRID, LookIn:=xlValues) 'wsTribalHist.Activate 'rFoundID.Select lTRRow = 3 lHistRow = rFoundID.Row + 2 lHistCol = rFoundID.Column wsTribalHist.Activate wsTribalHist.Range(Cells(lHistRow, lHistCol)).Select <--- Method range of object worksheet failed End Sub Any ideas why it doesn't recognize this range? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
macro to select range from active cell range name string | Excel Programming | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
Select Sheet then Select Range | Excel Programming |