![]() |
|
#1
|
||||
|
||||
![]()
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] |
#2
|
|||
|
|||
![]()
Thank you so much Paul. I'm a bit puzzled as to why such a simple operation is not catered for already without having to resort to a macro.
Anyway your macro did the trick - thanks again. Saved me a LOT of retyping ![]() |
![]() |
|
![]() |
||||
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 |