About
Pricing
Community
Teams
Start Free Trial
Log in
ADRIANA P
asked on
4/21/2017
I need macro to insert an character
i neeed an macro to insert □
character in any fiedl any time !
how i do any help please!!!
thnks in advanced !
Microsoft Excel
Microsoft Office
8
1
Last Comment
Martin Liss
8/22/2022 - Mon
Martin Liss
4/21/2017
Why do you need that particular character?
ADRIANA P
4/21/2017
ASKER
thnks Martin !
well is because i need eliminated the blank fields in the list of data
so that character help !
ASKER CERTIFIED SOLUTION
Martin Liss
4/21/2017
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P
4/21/2017
ASKER
That's what I mean !!!
Thnks !!!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Martin Liss
4/21/2017
You're welcome.
Martin Liss
4/21/2017
This will put an
invisible
character in the cell.
Sub NoBlank()
ActiveCell = Chr(160)
End Sub
Select all
Open in new window
ADRIANA P
4/21/2017
ASKER
That's better !!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss
4/21/2017
By the way, why do you need to do that?