This should be fairly simple. I have a column with X number of values and I'm trying to insert "=" at the begining of each cell data with a macro.
Existing data:
56
545
55
54
Need:
=56
=545
=55
=54
Any help would be appreciated.
This should be fairly simple. I have a column with X number of values and I'm trying to insert "=" at the begining of each cell data with a macro.
Existing data:
56
545
55
54
Need:
=56
=545
=55
=54
Any help would be appreciated.
Hi
If you select the range of cells and run this code, it should do what you want.
Alternatively, you can set the range you want to act upon within the code itself.
Please Login or Register to view this content.
--
Regards
Roger Govier
Microsoft Excel MVP
Alternatively:
If you wish to handle other data types you will need to adjust accordinglyPlease Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks