Table Cells
in [Beginners]
|
From: Ross from Orlando on 9 Jan 2010 15:17 On Jan 8, 10:36 pm, "macropod" <macro...(a)invalid.invalid> wrote: > Hi Ross, > > The following macro works in Word 2007 too: > > Sub CellAddress() > 'This macro displays the address of a table cell on Word's status bar > If Selection.Information(wdWithInTable) = True Then > If Selection.Cells(1).ColumnIndex > 26 Then > StatusBar = "Cell Address: " & Chr(64 + Int(Selection.Cells(1).ColumnIndex / 26)) & _ > Chr(64 + (Selection.Cells(1).ColumnIndex Mod 26)) & Selection.Cells(1).RowIndex > Else > StatusBar = "Cell Address: " & Chr(64 + Selection.Cells(1).ColumnIndex) & _ > Selection.Cells(1).RowIndex > End If > End If > End Sub > > -- > Cheers > macropod > [Microsoft MVP - Word] > > "Ross from Orlando" <ro...(a)rosspayne.net> wrote in messagenews:efe3a4eb-2f63-4060-b7ad-86471be0dcca(a)j24g2000yqa.googlegroups.com... > > > > > In Word 2007, is there a quick way to determine what table cell you > > the insertion point is in? I have a vague recolleciton of a feature to > > do this in earlier versions of Word. Thanks, > > > Ross- Hide quoted text - > > - Show quoted text - Well, I figured this out, and the long and the short of it is that both macros work. Thanks, Ross
From: Doug Robbins - Word MVP on 10 Jan 2010 01:25 Beware however of the potentially misleading result if the table contains merged cells. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Ross from Orlando" <rossp(a)rosspayne.net> wrote in message news:c309776c-90cc-4ce7-a20c-db9aedf0a864(a)a21g2000yqc.googlegroups.com... > On Jan 8, 10:36 pm, "macropod" <macro...(a)invalid.invalid> wrote: >> Hi Ross, >> >> The following macro works in Word 2007 too: >> >> Sub CellAddress() >> 'This macro displays the address of a table cell on Word's status bar >> If Selection.Information(wdWithInTable) = True Then >> If Selection.Cells(1).ColumnIndex > 26 Then >> StatusBar = "Cell Address: " & Chr(64 + >> Int(Selection.Cells(1).ColumnIndex / 26)) & _ >> Chr(64 + (Selection.Cells(1).ColumnIndex Mod 26)) & >> Selection.Cells(1).RowIndex >> Else >> StatusBar = "Cell Address: " & Chr(64 + >> Selection.Cells(1).ColumnIndex) & _ >> Selection.Cells(1).RowIndex >> End If >> End If >> End Sub >> >> -- >> Cheers >> macropod >> [Microsoft MVP - Word] >> >> "Ross from Orlando" <ro...(a)rosspayne.net> wrote in >> messagenews:efe3a4eb-2f63-4060-b7ad-86471be0dcca(a)j24g2000yqa.googlegroups.com... >> >> >> >> > In Word 2007, is there a quick way to determine what table cell you >> > the insertion point is in? I have a vague recolleciton of a feature to >> > do this in earlier versions of Word. Thanks, >> >> > Ross- Hide quoted text - >> >> - Show quoted text - > > Well, I figured this out, and the long and the short of it is that > both macros work. Thanks, > > Ross
First
|
Prev
|
Pages: 1 2 Prev: Full Screen and Status Bar in Word 2007 Next: need suggestion for calendar |