Help with Excel Macro selecting range

[largeselection]

Hi,

So I have some code but I need to select a certain range to copy/paste into a different workbook.

How can I have it copy a section above where it finds a specific value in a column?

So I want to code to copy from A9:J9 and all the way down until 2 rows above the row where the word "TOTAL" is found in Column A.

So would it be something like Range("A9:J & Find("TOTAL",A:A).offset(-2)

?

 

[Ruddles]

If the cell above "TOTAL" is empty you could do this:-

Range("A9:J" & Range("A9").End(xlDown).Row).Select

Based on your code, this should work:-

Dim oRange As Range
Set oRange = Columns("A").Find(What:="TOTAL", LookIn:=xlValues, LookAt:=xlWhole)
Range("A9:J" & CStr(oRange.Row - 2)).Select

 

[largeselection]

Thanks I was able to tailor this to get accomplished what I was looking for.

I appreciate your help!