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(EndDate), True) & _
"+" & Day(EndDate) & "+" & Year(EndDate) & "&output=csv"
2nd Example)
MessageLBC = "Special Fibonacci lookback averages choice." _
& Chr(10) & "5, 13 and 21 day averages - Choose 'OK'" _
& Chr(10) & "OR" _
& Chr(10) & "choose 'Cancel' " _
& Chr(10) & "to choose lookback, which doubles from first entry, like
8,16 and 32"
3rd Example:
Set QT = ActiveSheet.QueryTables.Add( _
Connection:="URL;" & Thisurl, _
Destination:=Range("A1"))
On Wed, Mar 7, 2018 at 3:25 PM, <excel-macros@googlegroups.com> wrote:
> excel-macros@googlegroups.com
> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/excel-macros/topics>
> Google
> Groups
> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview>
> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview>
> Topic digest
> View all topics
> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/excel-macros/topics>
>
> - Conditional formatting issue <#m_-4074006883849396307_group_thread_0>
> - 3 Updates
> - Trouble with VBA line break <#m_-4074006883849396307_group_thread_1>
> - 1 Update
>
> Conditional formatting issue
> <http://groups.google.com/group/excel-macros/t/37b4b89e28e7c919?utm_source=digest&utm_medium=email>
> vikas khen <vikk...@gmail.com>: Mar 07 05:08PM +0530
>
> Hi All,
>
> Request all of you to kindly help me on the attached sheet.
>
>
> I need conditional formatting for based on following two conditions
>
> 1) If the Actual date is less than or equal to Projected date it should
> highlighted in Green color
>
> and
> 2) If the Actual date is Greater than Projected date it should highlighted
> in Red Color
>
> Yor help in this regards will be highly appreciated.
>
> Thanks
> sourav devrani <souravdevrani1...@gmail.com>: Mar 07 08:05PM +0530
>
> PFA
>
> vikas khen <vikk...@gmail.com>: Mar 07 08:13PM +0530
>
> Thanks Sourav for your help.
>
> On Wed, Mar 7, 2018 at 8:05 PM, sourav devrani <
> souravdevrani1...@gmail.com>
> wrote:
>
> Back to top <#m_-4074006883849396307_digest_top>
> Trouble with VBA line break
> <http://groups.google.com/group/excel-macros/t/78ba51de1686f6c?utm_source=digest&utm_medium=email>
> Priti_Verma <pritiverma1...@gmail.com>: Mar 07 02:04AM -0800
>
> try this
> Range("T2").FormulaR1C1 =
> "=COUNTIF(RC17,""<94"")+COUNTIF(RC18,""<89"")+COUNTIF(RC19,""<90"")" _
> &
> "+COUNTIF(RC12,"">3.46"")+COUNTIF(RC13,"">2.82"")+COUNTIF(RC14,"">2.44"")+
> COUNTIF(RC15,"">2.31"")+COUNTIF(RC16,"">2.67"")"
>
>
> On Friday, March 2, 2018 at 10:07:27 PM UTC+5:30, Johnny wrote:
> Back to top <#m_-4074006883849396307_digest_top>
> You received this digest because you're subscribed to updates for this
> group. You can change your settings on the group membership page
> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/excel-macros/join>
> .
> To unsubscribe from this group and stop receiving emails from it send an
> email to excel-macros+unsubscr...@googlegroups.com.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
