I need macro to insert an character

ADRIANA P
ADRIANA P used Ask the Experts™
on
i neeed an macro to insert    □
 character in any fiedl any time !

how i do any  help please!!!

thnks in advanced !
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Why do you need that particular character?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
thnks Martin !
well is because  i need eliminated the blank  fields in the list of data
so that character  help !
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
If you'll settle for a slightly different character than select any cell and run this macro.

Sub NoBlank()
ActiveCell = Chr(11)
End Sub

Open in new window

Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Find out now!
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
That's what I mean !!!

Thnks !!!
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You're welcome.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
This will put an invisible character in the cell.

Sub NoBlank()
ActiveCell = Chr(160)
End Sub

Open in new window

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
That's better !!
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
By the way, why do you need to do that?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial