| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable = current cell in VB
Trying to make the variable z equal to the cell previously found by the scrip
Sheets("Eclipse").Selec Range("A1").Selec Cells.Find(What:="time", After:=ActiveCell, LookIn:=xlFormulas, LookAt :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= False).Activat Cells.Find(What:="days", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) .Selec z = Cells.Find(What:="days", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) .Selec Cells(z + 1, "B").Valu x = ActiveCell.Addres Selection.End(xlDown).Selec y = ActiveCell.Addres Range(x, y).Selec Application.CutCopyMode = Fals Selection.Cop Sheets("Sheet1").Selec Range("B2").Selec ActiveSheet.Paste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CURRENT TIME IN DESTINATION CELL IF SOURCE CELL IS TEXT | Excel Discussion (Misc queries) | |||
| How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| Send cell value to custom pane based on current cell/row? | Excel Discussion (Misc queries) | |||
| Syntax to define a variable for current file | Excel Programming | |||
Threaded Mode
