Would you recommend any Excel VBA book?

Thanks.



"Gary''s Student" wrote:

I am not a genius, only a student. Get a good book on Excel VBA, and in a
couple of weeks you will probably know more than me.
--
Gary''s Student - gsnu200746


"AccessHelp" wrote:

Gary,

You are genius. How did you know to do that? Can you give me some tips on
where I can go to learn those codes?

Thanks.


"Gary''s Student" wrote:

The following small UDF will return the formula as string without the = sign:

Function form2text(r As Range) As String
v = r.Formula
form2text = Right(v, Len(v) - 1)
End Function

--
Gary''s Student - gsnu200746


"AccessHelp" wrote:

Hi,

I have a formula "=A00011220" in Cell A1; however, the result of A1 is "A".

In Cells C1, D1 and E1, based on the formula in A1, I want them to show
"A0001", "12" and "20", respectively. The formula in A1 will be the same
format anytime.

Basically, is there a function in Excel that remove the "=" from a formula
and turn it into text or a function that turns the actual formula into text?

Thanks.