GrayLatto
11-24-2007, 09:29 AM
Dear excel experts,
I needed somebody's help concerning an issue I cannot solve. Here goes:
In the file that I have attached, I want to be able to paste in information cut from another workbook. This cut information is to be pasted into the row just above the most recent entry (in this case B4). I know for instance, that you could do CTRL Down after selecting Range B1, which would take you to cell B5, but what is the code to move up one cell?
The most recent entry will not always be cell B5, so, I do not want the code that does the following:
range("B:4).select
but rather I wanted a code that would just move up a cell from any cell.
I know this may sound confusing, but any help would be greatly appreciated, as I have such limited skills with computers.
Thanks again
I needed somebody's help concerning an issue I cannot solve. Here goes:
In the file that I have attached, I want to be able to paste in information cut from another workbook. This cut information is to be pasted into the row just above the most recent entry (in this case B4). I know for instance, that you could do CTRL Down after selecting Range B1, which would take you to cell B5, but what is the code to move up one cell?
The most recent entry will not always be cell B5, so, I do not want the code that does the following:
range("B:4).select
but rather I wanted a code that would just move up a cell from any cell.
I know this may sound confusing, but any help would be greatly appreciated, as I have such limited skills with computers.
Thanks again