going from one workbook to another in vba

[dinotom]

okay, so why does the code below set the two ranges (bold code) on the active workbook INSTEAD of wbMaster

Sub AdjustJPMPLforFutures()
Dim wbMaster As Workbook, wbSource As Workbook
Dim strTrader As String, lFuturesPL As Long, lEquityPL As Long
Dim dDate As Date, rngTemp As Range, rngTraders As Range, rngDates As Range
Dim iTraderPLOffset As Integer, cCell As Range, dCell As Range, x As Integer

x = 1
Set wbMaster = ThisWorkbook
With wbMaster
    [B]Set rngTraders = Range(Range("$A$2"), Range("$A$2").End(xlDown))
    Set rngDates = Range(Range("$B$1"), Range("$B$1").End(xlToRight))[/B]
End With

 

[NdNoviceHlp]

Because you told it to. ThisWorkbook is the active workbook and wbmaster equals it. HTH. Dave

 

[Norie]

Thomas

Your With is basically ineffective, none of the Range references within it actually refer to it.

Stick a dot in front of each instance of Range and see if that works.