--- "noskosteve" <noskosteve@...> wrote:
> 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.
That's "throw in" and ...
I have gobs and gobs of Debug.Prints in my code. Each SUB announces entry and exit to help with any tricky problem. I even do some creative indenting to help show what's happening when/where.
I stick them in as well whenever I want to see some value. Though I have used it, I haven't really learned to use the Watch Window much.
> 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]
> >
>
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
----------------------------------
Tidak ada komentar:
Posting Komentar