Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Macro to highlight alternating sections of a table Macro to highlight alternating sections of a table
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2020, 07:09 AM
Jennifer Murphy's Avatar
Jennifer Murphy Jennifer Murphy is offline Macro to highlight alternating sections of a table Windows XP Macro to highlight alternating sections of a table Office 2007
Competent Performer
Macro to highlight alternating sections of a table 		 
Join Date: Aug 2011
Location: Silicon Valley
Posts: 234
Jennifer Murphy is on a distinguished road
Default


Quote:
Originally Posted by macropod View Post
OK, try the following:
Wow! Thank you very much. I'll work on that today.
Quote:
Note that your parameters can specify any +ve value for the number of header rows.
Yes, I'll do some validity checking.

What is "+ve"?

Reply With Quote
  #2  
Old 02-21-2020, 02:49 PM
macropod's Avatar
macropod macropod is offline Macro to highlight alternating sections of a table Windows 7 64bit Macro to highlight alternating sections of a table Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
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 Jennifer Murphy View Post
What is "+ve"?
The opposite of -ve (i.e. 0 or greater)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-21-2020, 03:47 PM
Jennifer Murphy's Avatar
Jennifer Murphy Jennifer Murphy is offline Macro to highlight alternating sections of a table Windows XP Macro to highlight alternating sections of a table Office 2007
Competent Performer
Macro to highlight alternating sections of a table 		 
Join Date: Aug 2011
Location: Silicon Valley
Posts: 234
Jennifer Murphy is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
The opposite of -ve (i.e. 0 or greater)
Ok, but what does "ve" stand for? Maybe I'm too dense, but I've never seen that expression before? Is it an Aussie expression?
Reply With Quote
  #4  
Old 02-21-2020, 07:12 PM
macropod's Avatar
macropod macropod is offline Macro to highlight alternating sections of a table Windows 7 64bit Macro to highlight alternating sections of a table Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
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 Jennifer Murphy View Post
Is there a way for me to test whether there is a line before the table? That is, whether the table is the first thing in the document?
For example:
Code:
Sub Demo()
If Selection.Tables(1).Range.Start = ActiveDocument.Range.Start Then
 ' code for table at top of document
End If
End Sub
Quote:
Originally Posted by Jennifer Murphy View Post
Ok, but what does "ve" stand for? Maybe I'm too dense, but I've never seen that expression before? Is it an Aussie expression?
+ve = positive; -ve = negative
I'd have thought -ve was fairly common, +ve less so. See: What do -ve and +ve mean? - Quora
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 02-21-2020, 07:59 PM
Jennifer Murphy's Avatar
Jennifer Murphy Jennifer Murphy is offline Macro to highlight alternating sections of a table Windows XP Macro to highlight alternating sections of a table Office 2007
Competent Performer
Macro to highlight alternating sections of a table 		 
Join Date: Aug 2011
Location: Silicon Valley
Posts: 234
Jennifer Murphy is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
For example:
Code:
If Selection.Tables(1).Range.Start = ActiveDocument.Range.Start Then
 ' code for table at top of document
End If
Perfect, thanks

Quote:
+ve = positive; -ve = negative
I'd have thought -ve was fairly common, +ve less so. See: What do -ve and +ve mean? - Quora
Aha! Now I get it.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to highlight alternating sections of a table Macro to highlight a list of words bakerkr Word VBA 4 10-19-2017 02:23 PM
Macro to highlight alternating sections of a table Word 2010 VBA Print Macro - Specified Sections Benbon Word VBA 3 03-30-2017 02:31 PM
Macro to highlight alternating sections of a table Macro Question: Need help making a macro to highlight the first word in every sentence LadyAna Word 1 12-06-2014 10:39 PM
Macro to highlight alternating sections of a table Macro to highlight words bertietheblue Word VBA 9 07-01-2013 12:39 PM
find - reading highlight - highlight all / highlight doesn't stick when saved bobk544 Word 3 04-15-2009 03:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:09 AM.

Contact Us - Privacy Statement - Top

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