Something told me there would be such code...
While, to keep file size down, I frequently think that I'll remove them all before "releasing" a Workbook, Tracking versions is a pain and I just decide to leave them in.
However, since it is available, please send it (unless it is already in the Files Area) and I'll add it to the long list of hints n' kinks n' Ho-To's in my VBA folder.
"Insert them" ... ? ? Like ... how/where?
Regards, Steve
--- In ExcelVBA@yahoogroups.com, 1z@... wrote:
>
>
> I have code to delete those Debug.Prints if you want it and also to insert them?
>
> Lisa
>
> Sent: Fri, Apr 13, 2012 12:44 am
> Subject: [ExcelVBA] Re: Using Literals in Formulas
>
>
>
>
> --- "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
> Range with a Range name like "ColA", then using that name in whatever formula
> ou 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.
>
> hat's "throw in" and ...
> I have gobs and gobs of Debug.Prints in my code. Each SUB announces entry and
> xit to help with any tricky problem. I even do some creative indenting to help
> how what's happening when/where.
> I stick them in as well whenever I want to see some value. Though I have used
> t, 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
> efining a variable to hold the string and displaying it either with a
> ebug.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