I am using the attached code for converting numbers (currency) into text. The code was working fine but now gives a
"Compile error : Cant find project or library"
please help to find what has gone wrong now. the code stops at "ReDim Place(9) As String" line.
I have a huge list, I want to change my reference columns data from number to text. I don't want to add any new column and for instance, use text() function. I am just wondering if it is possible to do that in place with a VBA code or not. I tried
Hi There -
I am trying to take convert my variable LC1 into a letter. Please see code below. I need to replace the hardcoded "C" with the equilvalent letter of LC1. Thanks!
Dim LR1 As Long
Dim LC1 As Long
LR1 = Range("A:AO").Find("*", SearchOrder:=xlByRows...
I would like to take all numbers in column C of my spreadsheet and turn them into text based on the text value I gave each number.
Ex: I would type the number "1" into cell C1 and excel would automatically convert it into the word "New York". If I typed "2" into a cell it would convert in into...