Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-02-2014, 06:52 AM
bgranzow bgranzow is offline Help Writing VBA Code using the HideMark property Windows 8 Help Writing VBA Code using the HideMark property Office 2013
Novice
Help Writing VBA Code using the HideMark property
 
Join Date: Jan 2014
Posts: 12
bgranzow is on a distinguished road
Default

The problem is that whether the row is filled or not depends on a number of variables in the records I am sinking. And at over 300 records, manual deletion would be a pain. Does anyone know how to write the VBA code for the Hidemark property?
Reply With Quote
  #2  
Old 06-02-2014, 04:10 PM
macropod's Avatar
macropod macropod is online now Help Writing VBA Code using the HideMark property Windows 7 32bit Help Writing VBA Code using the HideMark property Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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

Quote:
Originally Posted by bgranzow View Post
The problem is that whether the row is filled or not depends on a number of variables in the records I am sinking. And at over 300 records, manual deletion would be a pain. Does anyone know how to write the VBA code for the Hidemark property?
I wasn't suggesting manual deletion - it can be done quite easily with a macro. I also suggested you might consider re-doing the mailmerge so it only creates those rows you actually require.

The code provided by jpb103 will delete (not just hide) the entire row if even just the first cell on the row is empty. It's not clear whether that's what you want, or whether the entire row must be empty.

At this stage, you haven't provided enough information for anyone to know what kind of table your mailmerge generates. For example, do the number of records for each table vary, or is it that some records have empty fields. If it's the former, a Directory merge may be the way to go, instead of the Letter merge you're now using.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
hidemark, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Link Watermark to custom property kerend Word 0 04-08-2012 05:03 AM
Help Writing VBA Code using the HideMark property QuickParts - custom document property untttt Word 2 06-09-2011 05:24 PM
Help Writing VBA Code using the HideMark property Access to the property of the current table b0x4it Word VBA 2 05-26-2011 06:25 AM
Writing code with C# and VB.NET to create Outlook add-ins and other projects kistou Outlook 0 01-13-2010 04:23 AM
set icon for user property nav1982 Outlook 0 11-11-2009 05:40 AM

Other Forums: Access Forums

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