Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-13-2011, 12:25 AM
SCMiller SCMiller is offline Keeping Table on One Page Windows Vista Keeping Table on One Page Office 2007
Novice
Keeping Table on One Page
 
Join Date: Apr 2011
Posts: 4
SCMiller is on a distinguished road
Default


Thanks! I greatly appreciate your help!
Reply With Quote
  #2  
Old 08-22-2016, 03:33 AM
andyroberts1234 andyroberts1234 is offline Keeping Table on One Page Windows Vista Keeping Table on One Page Office 2010 32bit
Novice
 
Join Date: Dec 2015
Posts: 2
andyroberts1234 is on a distinguished road
Default Vertically merged cells cause runtime error

Hello,

I have been trying to run this code however come across the following error:

Runtime error 5991: Cannot access the individual rows of this collection because the table has vertically merged cells.

Is there a way to make it work with tables with merged cells, or if not to do something like 'if table has merged cells then skip the formatting of this table'?

For clarity, this is the code I am running:

Code:
Sub ApplyTableAttribute()
'
' ApplyTableAttribute Macro
'
'
Dim oTbl As Table, oCel As Cell
' for each table in the active document
For Each oTbl In ActiveDocument.Tables
'set paragraphs to keep with next
  oTbl.Range.Paragraphs.KeepWithNext = True
  ' for each cell in the last row of the table
  For Each oCel In oTbl.Rows.Last.Range.Cells
  ' 'set the last paragraph to not keep with next
    oCel.Range.Paragraphs.Last.KeepWithNext = False
  Next oCel
Next oTbl
End Sub
Thanks

Andy
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping Table on One Page Page Numbers in Table of Contents MerRob54 Word 6 01-28-2013 03:37 AM
Keeping Table on One Page Table Jumps to Next Page donthaveaclue Word Tables 3 02-25-2011 07:54 AM
Keeping Table on One Page table spanning full page datto210 Word Tables 1 10-25-2010 12:39 PM
Keeping Table on One Page Table rows moving to new page when you don't want them to graham Word Tables 1 11-16-2009 08:51 AM
Automatically recreate table on next page oneononemedia Word Tables 0 08-16-2009 08:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft