How to get Excel cell Value in VBA with single quo

Question

How to get Excel cell Value in VBA with single quote if in the starting of text.

For Eg. Cell A1 has Value '123. I get value 123 only in VBA. I need '123.

Answer 1

As this answer shows, you can use .PrefixCharacter to get the initial single quote mark (if any), which then be concatenated with the value of the cell:

Range("A1").PrefixCharacter & Range("A1").Value