Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ofind
Hey folks,
Got a bit of code running to setup the sheet since the columns keep changing order at the download. So I got this running to about BP1. Anyway, it's not picking up the ID. Instead it's picking up OpportunityID. SO column A, B both populate with OpportunityID, any thoughts? Dim oFind As Range Set oFind = Range("1:1").Find("ID") If Not oFind Is Nothing Then oFind.Resize(2000, 1).Copy _ Destination:=Worksheets("Raw Data").Range("A1") End If Set oFind = Range("1:1").Find("OpportunityID") If Not oFind Is Nothing Then oFind.Resize(2000, 1).Copy _ Destination:=Worksheets("Raw Data").Range("B1") End If |