Offset(9,0) positive number used Negative numbers to retrieve data

[bannowindjammer]

Hi Everyone,
I am not understanding how this is working...

Attached you will find a simple workbook 1 sheet 1 column of data 9 rows long when the user form is up and you click the button the following executes

Dim editvalue As Range
Dim EV As Range
Dim nb As Integer
Dim LRow As Long
Dim LListRow As Long
Dim BMatch As Boolean
Dim tmp As String
Dim tmp2 As String
Dim ColumnNumber As Long
Dim x As Integer

tmp = ""

Worksheets("Position Packs").Select
Set editvalue = Sheet9.Range("C:EE").Find(what:=emppack, LookIn:=xlValues)
tmp = editvalue.Address(0, 0)
'Convert To Column Number
'ColumnNumber = Range(tmp & 1).Column
ColumnNumber = Range(tmp).Column
nb = WorksheetFunction.CountA(Columns(ColumnNumber))

(Positive) 'nb=9

Set editvalue = Sheet1.Range("C:EE").Find(what:=emppack, LookIn:=xlValues).Offset(nb, 0)

(Negative) For x = -1 To -nb Step -1

Me.tb1.Value = editvalue.Offset(x, 0)
Stop

Next

Trying the for x with 1 thru 9 does not work (Positive numbers as they were pulled).

but when I go to retrieve the data I need to use a negative number and I do not understand why?
I only want to pull the 8 entries under the header "ALL".

Also, I'm all ears and eyes if there is a better way to do this.

Thank you!

[Mumps1]

Rather than trying to decipher your code, it might be easier to help if you could include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets.

[bannowindjammer]

I did it is below the code.

Thank you

[Mumps1]

Is the macro doing what you wanted?

[bannowindjammer]

yes, but not as expected.
I originally made the For x = 0 to 9 loop

with positive numbers and got no results.... Used negative numbers (just to find the data) and found the data That's the part I do not get??!!??

with offset going up in a column is negative.. but I'm reading down (Positive) but getting the data with neg number -1 through -9, not 1-9??


Mumps1 I do Apologize if I am not making sense here.

[Mumps1]

The way your code is written, the variable "editvalue" will return as empty with no value. What is the expected result based on your data? Also, why are you searching C:EE for the word "ALL"? If you explain in words what you are trying to do, step by step, to get the expected result, it would be easier to follow.

[bannowindjammer]

Ok here is what I would like to accomplish.

1. Search for Header in this case "ALL" and read the data below it.

2. with the data from list "ALL" search list#2 for match and use this as the result.

Thanks

[Mumps1]

Where is list #2 and what values do you want to match?