If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto creating rows
I am trying to construct a worksheet that needs to copy the formulae in
the current row. If I do this manually by pulling down the right bottom handle my worksheet shows the cell color and prints to the end of the column created when the original cell is pulled down. I do not want either. To explain it more fully - I have 7 columns 3 of which contain a formula. 4 of the columns are colored for ease of defining their purpose. Data is entered by the row and it is only when the ENTER key is pressed that the row colors and formulae show be created on the next empty row. Can someone help? Orf Bartrop |
#3
|
|||
|
|||
Auto creating rows
I am afraid you have lost me, Don. I could not find the worksheet_change
event. What I have is 4 cells B6, C6, D6 and E6 each capable of accepting data. There are no formulae attached to these cells, however they are each separately formatted. What I want is to do is if the Enter key is pressed when the focus is in any of these cells then reproduce the format and formulae in cells A7-G7, where A7, F7 and G7 each contain a formula and formatting. However if G5 is not blank I do not want the next row changed, instead change the focus to the B cell in the last empty row. By the way, thanks for your answer to the Exit button problem. Works fine. Orf Don Guillett wrote: Have a look at using the worksheet_change event in the sheet module |
Thread Tools | |
Display Modes | |
|
|