Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-29-2012, 07:23 PM
ubns ubns is offline Macro for selecting pages and formatting of tables Windows 7 32bit Macro for selecting pages and formatting of tables Office 2010 32bit
Competent Performer
Macro for selecting pages and formatting of tables
 
Join Date: Apr 2012
Posts: 177
ubns is on a distinguished road
Default Macro for selecting pages and formatting of tables

a. How can we design the macro to make a selection from one particular page to another particular page?
b. Once selected, do the following in the tables within those pages:


i. Delete – All rows including Date.
ii. Delete – All rows starting with “age”.
iii. Delete – All Zero Rows.
iv. Remove all rows with % symbols in them.
v. Add $ sign to all the numbers.
vi. Replace “>” with “five blank spaces”
vii. Spacing of cell – Before 5 pt, After 2 pt.
viii. Change the font size to 9.
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 06:02 AM.


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