question

DavidKellett-5835 avatar image
0 Votes"
DavidKellett-5835 asked DavidKellett-5835 answered

Text is not printing every thing in the line

I have the following code:

Range("L4").Value = "'1-4(1)"

For some reason it puts the "1-4" in the cell but not the "(1)". Does anyone have any ideas on how to change this line so that it prints out the whole text?

Thank you,


Dave

office-vba-devoffice-scripts-excel-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Do you see the correct value in Formula Bar for this cell?


0 Votes 0 ·

1 Answer

DavidKellett-5835 avatar image
0 Votes"
DavidKellett-5835 answered

I do see the value but it does not show the (1) part either.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.