Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to set z as the active cell then have x equal to the active cell + 1 or the cell below, The z factor can be skipped if possible. My code i
Sub Macro3( ' Macro3 Macr ' Macro recorded 2/24/2004 by Husky Use Dim z As Rang 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 Set z = ActiveCel Cells(z + 1, "B").Select <--------------------error that you can not add a 1 to z 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.Past End Su |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
set the background color of the current cell(active cell) | New Users to Excel | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) | |||
Sum to active cell | Excel Discussion (Misc queries) |