We help IT Professionals succeed at work.

I need macro to insert an character

119 Views
Last Modified: 2017-04-21
i neeed an macro to insert    □
 character in any fiedl any time !

how i do any  help please!!!

thnks in advanced !
Comment
Watch Question

Martin LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
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 !
Protect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
That's what I mean !!!

Thnks !!!
Martin LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You're welcome.
Martin LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
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 LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

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