Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
below, I'm finding a cell if it contains string "myword", then i'm trying to
copy (buy I'd rather move the cell 1 cell to the right from where it's found). I need help on the cell copy (preferably move) part. No matter what variables I change in the OFFSET part, I can't get the contents in the found cell to copy (preferably move) 1 cell to the right. My function FINDCELL works good. Usage: MoveCell("myword") Sub MoveCell(ByVal sSearchString As String) Dim cell As Range Set cell = FindCell(sSearchString, Sheets(1).Cells) If cell Is Nothing Then 'action to take of no match Else cell(0, -1).Value = cell.Value End If End Sub Function FindCell(searchFor As String, _ searchRange As Range) As Range Application.DisplayAlerts = False With searchRange Set FindCell = .Find(what:=searchFor, After:=.Cells(.Cells.Count), _ LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False) End With End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How move arrow keys from cell to cell and NOT entire col/rows | New Users to Excel | |||
How do I move from cell A 10 to cell B1 with one move or click | Excel Worksheet Functions | |||
Arrow keys move screen instead of moving from cell to cell | Excel Discussion (Misc queries) | |||
How do I make my arrow buttons move from cell to cell in Excel? | Excel Discussion (Misc queries) | |||
Arrow keys move screen instead of moving from cell to cell. | Setting up and Configuration of Excel |