Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search a column for the last five cells?
Hi all,
i have a small problem and it follows: I need to search 1 column ( say A ) and find the last cell. From there i want to step five cells back, copy every value for each on and paste them into a specific textbox i have in a userform. My code so far look like this: Do If IsEmpty(ActiveCell) = False Then ActiveCell.Offset(1, 0).Select End If Loop Until IsEmpty(ActiveCell) = True Dim nr1 As Integer, nr2 As Integer, nr3 As Integer, n4 As Integer, nr5 As Integer ''''This is the values i want to put in my textboxes!!! nr1 = ActiveCell.Offset(-1, 0).Select And ActiveCell.Copy nr2 = ActiveCell.Offset(-1, 0).Select And ActiveCell.Copy nr3 = ActiveCell.Offset(-1, 0).Select And ActiveCell.Copy nr4 = ActiveCell.Offset(-1, 0).Select And ActiveCell.Copy nr5 = ActiveCell.Offset(-1, 0).Select And ActiveCell.Copy End Sub PS Im a beginner, started last week so please try to keep it simple :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search adjacent cells in Column for sequence | Excel Worksheet Functions | |||
LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
search column of text cellto identify those cells with specific w | Excel Worksheet Functions | |||
Fast way to search many cells by column for text strings | Excel Discussion (Misc queries) |