|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|
Working with a nesting table from inside a nested table - switchingrows.
Imagine you have a table, and nested in each cell is a table. Your
selection is inside one of the nested tables. You want to switch the
row containing your selected table with the row above it. What makes
this a bit tricky is that (it seems) you can't directly identify the
nesting (exterior) cell/row/table.
Below FWIW is the code I came up with. It seems to work fine, but I'm
hoping/expecting there's a more elegant and robust way to do it.
[An additional constraint I was working with was that if your nested
table is already in the top row of the nesting table, it should seem
to the user as if nothing at all happened; e.g. the cursor should stay
in the same spot. Hence the NestingRowIndex function.]
Dim DeleteMe As Row
If NestingRowIndex 1 Then
Set DeleteMe = Selection.Rows(1)
MsgBox ("You're at the top already.")
'You're in a nested table. What is the row number of cell in which
the table is nested?
Dim testRange As Range
Set testRange = Selection.Range
NestingRowIndex = testRange.Cells(1).RowIndex
PS my approach was based on a suggestion by Cindy Meister,
|Thread||Thread Starter||Forum||Replies||Last Post|
|Word 2003 "paste as nested table" not nesting||[email protected]||Tables||0||August 14th 07 11:42 PM|
|Enter inside table moves the table||Monika Bjurman||Tables||4||July 10th 07 04:56 PM|
|Creating a table inside an existing table||Eric Schmieder||Tables||2||October 13th 05 05:45 PM|
|Drawing a table inside of a table||Luc||New Users||1||August 23rd 05 10:43 AM|
|How can I draw a table inside of a table?||avinoam.aharoni||New Users||5||June 29th 05 07:12 PM|