In VBA i cobine to cells to one. But i want a space between. I tried this but it doesn't work.
Please Login or Register to view this content.
In VBA i cobine to cells to one. But i want a space between. I tried this but it doesn't work.
Please Login or Register to view this content.
Just a punt - did you try doubling up?
Please Login or Register to view this content.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Why would you keep changing the same cell (range("P17")) in a loop. Where does i come from in the second part of the codeline ?
Did you try Space(1) instead ?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Just noticed that there's a space after the H in second part. Remove that and you're fine.
The complete script.
The & "" "" & isn't workingPlease Login or Register to view this content.
Read my Post #4.
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks