About Pricing Community Teams Start Free Trial

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 ExcelMicrosoft Office

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

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?

Certified Expert Program

Credly Partnership

Udemy Partnership