![]() |
#2
|
||||
|
||||
![]()
Hi colliedug,
Here's a macro to do the work. Simply select the column then run it. Code:
Sub SubtractOne() Application.ScreenUpdating = False Dim i As Long, Rng As Range With Selection If .Information(wdWithInTable) Then For i = 1 To .Rows.Count With .Columns(1).Cells(i) Set Rng = .Range With Rng .End = .End - 1 If IsNumeric(.Text) Then .Text = .Text - 1 End With End With Next End If End With Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with reducing pptm file size | vbapptnew123 | PowerPoint | 1 | 06-11-2011 06:24 PM |
Numbers in Words | janak | Excel | 2 | 12-19-2010 08:53 PM |
Increment Numbers Help | Jazz43 | Word | 2 | 07-30-2010 02:48 AM |
page numbers and TOC | windon | Word | 0 | 09-09-2009 07:53 AM |
Equation Numbers | BillG | Word | 0 | 08-04-2009 08:02 AM |