Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 04-30-2012, 08:37 PM
macropod's Avatar
macropod macropod is offline Macro for selecting pages and formatting of tables Windows 7 64bit Macro for selecting pages and formatting of tables Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Actually, instead of changing:
If bDel = True Then .Delete
to:
If bDel = True And i > 1 Then .Delete
it would be more efficient to change:
For i = .Rows.Count To 1 Step -1
to:
For i = .Rows.Count To 2 Step -1
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Another Case of Automatic/Zombie Formatting of Tables MKummerfeldt Word Tables 0 10-31-2011 10:40 AM
Splitting multiple pages using macro F5JASON Excel Programming 0 07-27-2011 08:22 AM
Selecting the macro document lars Word VBA 0 08-19-2010 06:06 AM
Whacked formatting in tables (2007) Roscoe Word Tables 6 06-11-2010 02:48 PM
Macro for selecting pages and formatting of tables Keeping Tables from Splitting Between Pages AlexPaoletti Word Tables 2 05-18-2010 01:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:40 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