Application screenupdating false application cutcopymode false Chine sex chatting no sign
Paste Special xl Paste Values Range(Cells(i, 1), Cells(i, 11)).
Name = "Table2" End Sub You could, of course, scrap the table formats (at least in sheet2) and revert to the original code.
As I don't know how large your data set is, I've just assumed that it stretches from Column A to Column N.
Delete '---- As you can see, I've added some notes beside each line of code so that you can understand what the code is doing. Click on the Transfer Data button to see the code work.
Your macro can access any cells in the workbook, unless the worksheet containing the cell is hidden.
Delete '---- As you can see, I've added some notes beside each line of code so that you can understand what the code is doing. Click on the Transfer Data button to see the code work. Cheerio, vcoolio Hi, I had a similar query and tried the sample spreadsheet for my data transfer, which works fine so thank you very much. Its just that the spreadsheet at our end will be used by various people in the team with varied levels of IT skills. I only this day received notification that you had on 6/12/2017 posted to this now very old thread! However, just in case you are still out there (and it just may no longer matter to you now), the fix to your little issue is a matter of qualifying that a last row exists after rows are deleted. End(xl Up)(2) ' Copies row data from Columns A - N & transfers it _ to sheet2 into the next available row. Screen Updating = False Dim i As Integer Dim lr As Long lr = Range("A" & Rows. Your data starts in A5 and stretches out to Column K. - Your data set is in table format which normal code won't adapt to. Following is a revised code to cover the above:- Sub Transfer Data() Application. If you want to avoid this, then use the following line of code at the beginning of your macro: With screen updating turned off in this way, nobody will ever know that you unhid a worksheet and later rehid it.Make sure that before ending the macro, however, you set the Screen Updating property back to True.
is your source for cost-effective Microsoft Excel training. You can find a version of this tip for the older menu interface of Excel here: Running Macros on Hidden Worksheets.