Search results

The delete part is fine, the problem is the copy part. [CODE] Sheets("Sheet1").Rows("1:1").Copy Sheets("Sheet4").Range("A1") [CODE] The line above don't work. Thanks, Le

Yes! :) Thanks, Le

Here is the worksheet. I would like the value in first row of the first sheet to be copy in sheet4. Thanks, Le

No, it doesn't work. Yes, I want to copy the entire row where the cell have a value. Thanks, Le

Thanks, it doesn't copy the whole row, it copy one cell only which is F1. Thanks, Le

Hi, I have written a code that copy the first row in sheet1 to sheet4 and then, delete the first row from the sheet1 to sheet3. However this don't work. Please see code. Thanks, For Each Cell In [A1:F1] Cell.Select Selection.Copy Worksheets(4).Paste...

No is not too late. Thanks. How can I count to the late row and then using this value to subtract by 1? Something like this Sheet2.range("A1") = Sheet1.range("last_row_number") Sheet2.range("A2") = Sheet1.range("last_row_number -1") etc... How can you write the above code to do automatically...

Hi, How can I inverse a matrix in Excel? Example, I have 3 rows and in each row I have 10 values. I would like to copy this values in a inverse order, it likes a mirror of data. Please see attachement. Thanks, Le888

Thanks, Le888

Is it possible to have the data of this curve? If yes, how? Thanks, Le888

Hi, How can you do a curve fitting with these data. Please see attachement. Thanks, Le888

Hi, Is it possible to add two x axes? I know when you plot in Excel, it is possible to add two y axes but to add an other x axe on the top of the graphic, is it possible? Thanks, Le

Here is a quit example... Le

Is the same thing you did with the frmMainClient and frmJob. You open frmJob and insert frmSuppliers by using wizard insert form. Le

You can put the frmSuppliers in the frmJob and linked to supplierID. This means that the frmSuppliers is the subform of frmJob. Le

Try this... Le

Yes, my version is 2000, so I can not read your version. So, save your database in version 2000 than I can read it. Le

I have Access 2000, what is your version? Le

I have extract your database but after I can not read it. I open it but it said unknown data. Le

See if this what you want... If you click on "Grainger" than the part number is "2W199" which corresponds to "Item 123", etc. Le