The code below pads every cell in the range with a trailing space. As part of the same macro, I need to insert a space in front of any question mark (the character, not the wild card) where a space is not already present. How would I add this to the code?
Please Login or Register to view this content.
Try this.
Also, it's not a good coding practice to name a variable the same as a VBA keyword; Dim Range As Range. I've seen it cause erratic behavior. I changed the variable to rng.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks for the code, and the tip.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks