Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 1 update in 1 topic

2018-04-30 Thread David Lanman
Hello Kaushik, I am sorry, but can you send me what you had posted before? I have lost the original description of you needs. Thanks, David On Sun, Apr 29, 2018 at 4:25 PM, wrote: > excel-macros@googlegroups.com >

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 15 updates in 13 topics

2018-04-25 Thread David Lanman
Is this group no longer for asking questions about Excel VBA? I see nothing but hiring information and nothing about VBA. Thanks, David On Wed, Apr 25, 2018 at 4:23 PM, wrote: > excel-macros@googlegroups.com >

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 2 topics

2018-03-07 Thread David Lanman
These are examples of using several line breaks. I hope they will help: 1) qurl = "http://finance.google.com/finance/historical?q="; & Sym qurl = qurl & "&startdate=" & MonthName(Month(StartDate), True) & _ "+" & Day(StartDate) & "+" & Year(StartDate) & _ "&enddate=" & MonthName(Month(End

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 2 updates in 2 topics

2018-02-24 Thread David Lanman
Can you specify the number of decimal places you want? Or does that change and if so can you specify the conditions that will give specific decimal places? Thanks, David On Sat, Feb 24, 2018 at 3:32 PM, wrote: > excel-macros@googlegroups.com >

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics

2017-12-19 Thread David Lanman
How about simply copy and paste values and do it to the the whole sheet? Sub CopyPastVal() Cells.Copy Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub Thanks, David On Tue, Dec 19, 2017 at 3:31 PM, wrote: > excel-macros@googlegrou

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 2 updates in 2 topics

2017-05-29 Thread David Lanman
It seems the first question must be "what is purpose, what are you trying to accomplish?" thanks, David On Mon, May 29, 2017 at 4:26 PM, wrote: > excel-macros@googlegroups.com > > Google > Groups >