Link to home
Create AccountLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

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 !
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Why do you need that particular character?
Avatar of ADRIANA P

ASKER

thnks Martin !
well is because  i need eliminated the blank  fields in the list of data
so that character  help !
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
That's what I mean !!!

Thnks !!!
You're welcome.
This will put an invisible character in the cell.

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

Open in new window

That's better !!
By the way, why do you need to do that?