[ExcelVBA] Re: Using Literals in Formulas

 

Hopefully I'm not missing something here. but...
(Named Ranges to the rescue...)

Ignoring the other (formula) comments for the moment. How about naming the col A Range with a Range name like "ColA", then using that name in whatever formula you end up with like this:

Range("B1").Value = "= ""Ripe "" & ColA & "" Cheap"""

A little Cut and Paste and it just worked for me in Excel 2007.

--
I tune-in periodically and through in a comment or two.
73, Steve, N. K9DCI

--- In ExcelVBA@yahoogroups.com, Michael Trombetta <mickey11030@...> wrote:
>
> Thank you David and Derek,
>
> I will spend the next few days digesting your comments. The suggestion of defining a variable to hold the string and displaying it either with a Debug.Print or a MsgBox statement is particularly helpful.
>
> Thanks again,
> Mickey
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (8)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___