Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from cell above
I know that "Selection.End(xlToLeft).Select" will select the first cell
in the current row. What would it take to then copy the contents of the cell above into the active cell and then select the cell (in the current row) in column X |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from cell above
if i'm understanding what you want, maybe this:
activecell.value = activecell.Offset(-1).value -- Gary "Patrick C. Simonds" wrote in message ... I know that "Selection.End(xlToLeft).Select" will select the first cell in the current row. What would it take to then copy the contents of the cell above into the active cell and then select the cell (in the current row) in column X |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from cell above
Thank you, almost there.
Now I need it to then select the cell (in the current row) in column X "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... if i'm understanding what you want, maybe this: activecell.value = activecell.Offset(-1).value -- Gary "Patrick C. Simonds" wrote in message ... I know that "Selection.End(xlToLeft).Select" will select the first cell in the current row. What would it take to then copy the contents of the cell above into the active cell and then select the cell (in the current row) in column X |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column | Excel Programming | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) |