View Single Post
 
Old 02-25-2014, 04:49 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit 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

Quote:
Originally Posted by ekesawi View Post
After running the macro, all I had to do is to replace tabs with the default number of space in IDEL
You could eliminate that step by changing every occurrence of vbTab with "__" (i.e a pair of double quotes with two spaces [or a different number of spaces] between them). For the first macro, you could even concatenate the vbTab, vbTab & vbTab etc. sets into single strings of "__", "____" and so on.

PS: I've inserted '_' characters because the board software deletes repeated spaces.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote