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 |
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 |
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 |
All times are GMT +1. The time now is 12:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com