Arthur Fuller
fuller.artful at gmail.com
Mon Dec 24 10:45:07 CST 2007
Thanks, Tina. Just after sending my mail, I remembered that when in doubt, create a macro then customize its code to suit my needs. A. On 12/24/07, Tina Norris Fields <tinanfields at torchlake.com> wrote: > > Hi Arthur, > > Responding to the third question - Copy > Edit > Paste Special > > Values. I use this one often enough that I have put the appropriate > button on my toolbar so I don't have to go to the menu. > > Responding to the second question - unless you are specifically looking > for a programmatic method, you can use CTRL + arrow key to move to the > next change in filled versus non-filled, then one more touch of the > arrow key alone puts your cursor into the blank cell. > > For the first question, are you wanting to delete the whole Row 3, or > only in one table? If the whole row, then select the row by clicking > the row selector on the left frame, then Edit > Delete - using the DEL > key just empties the row contents and leaves the blank row there. If > you just want to delete Row 3 in one table, select the cells to be > deleted, then Edit > Delete. . . > Shift Cells Up - again, using the DEL > key just empties the contents of the cells and leaves the blank ones > there. > > In the past, I have worked out a macro for doing the addition of a new > row at the bottom edge of a table and then fixing the formatting. The > trick was to record the macro, then edit the VBA code to be sure the > relative reference coding was in place. Before I did that, I made my > table always two rows longer than I really wanted and used the > next-to-last row for all increases. > > I hope some of this is helpful - if it needs to be programmatic rather > than keyboard and mouse manipulation, I'll do some further digging. > > Are you having any Christmas cheer, yet? A good day over here in chilly > northern Michigan for a hot buttered rum or something similar. > > Tina > > Arthur Fuller wrote: > > I have a workbook containing 3 tables side by side. The range of table 1 > is > > A3:D15, of table 2 it's F3:F15, of table 3 it's K3:N15. > > > > What I need to do is lose Row 3 and then insert a new row at Row 15. But > > because the table has borders, what was row 15 orignally now has a > bottom > > edge, and the new row 15 doesn't. I know how to do a selection and kill > its > > formatting, and then do another selection and give it a bottom border, > but > > that is so clumsy. > > > > First of all, what are commands to delete a row and to insert a row? > > > > Second, it happens that frequently some rows in the table have not been > > filled yet. In that case, I'd like to find the first blank row and do > the > > row insert there, thus simplifying the the formatting code > > > > Third, how to you copy just the value from a cell to another cell, > without > > copying the formatting too? > > > > Thanks and Happy Holidays to all. > > Arthur > > _______________________________________________ > > dba-Tech mailing list > > dba-Tech at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-tech > > Website: http://www.databaseadvisors.com > > > > > _______________________________________________ > dba-Tech mailing list > dba-Tech at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-tech > Website: http://www.databaseadvisors.com >