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
> 
>  Google
> Groups
> 
> 
> Topic digest
> View all topics
> 
>
>- Need Macro <#m_4756874363710315299_group_thread_0> - 1 Update
>
> Need Macro
> 
> KAUSHIK SAVLA : Apr 29 03:24PM
>
> Hi David,
>
> Please let me know what additional information is needed.
>
> Regards,
> Kaushik Savla
>
> Back to top <#m_4756874363710315299_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
> 
> .
> 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.

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
> 
>  Google
> Groups
> 
> 
> Topic digest
> View all topics
> 
>
>- Hiring for Performance Tester w/ Java Environment Exp. in New York,
>NY <#m_2618516904678938844_group_thread_0> - 2 Updates
>- Need Java FullStack Developer at Sunnyvale, CA.
><#m_2618516904678938844_group_thread_1> - 1 Update
>- Hiring for Sr.Net Developer (9+ years) in Morris County, NJ
><#m_2618516904678938844_group_thread_2> - 2 Updates
>- Immediate hire for SAP Vistex functional Consultant at St Louis, MO
><#m_2618516904678938844_group_thread_3> - 1 Update
>- Immediate hire for SAP EWM Functional Lead at Atlanta, GA
><#m_2618516904678938844_group_thread_4> - 1 Update
>- .Net Developer/ Azure Application Developer at Princeton, NJ-08540
><#m_2618516904678938844_group_thread_5> - 1 Update
>- Requirement: Business Systems Analyst - Pega CRM - Norfolk VA
><#m_2618516904678938844_group_thread_6> - 1 Update
>- Immediate hire for SAP FICO at St Paul, MN
><#m_2618516904678938844_group_thread_7> - 1 Update
>- 9to9 Requirement: Pega Admin - Norfolk VA
><#m_2618516904678938844_group_thread_8> - 1 Update
>- Need Core Java Developer at Sunnyvale, CA
><#m_2618516904678938844_group_thread_9> - 1 Update
>- Dot Net Training in Ncr | Best Dot Net Training Gurgaon – SSDN
>Technologies <#m_2618516904678938844_group_thread_10> - 1 Update
>- Immediate hire for SAP SD at Lake Zurich, IL
><#m_2618516904678938844_group_thread_11> - 1 Update
>- 24*7 Instant Technical Support Hotmail (UK)
><#m_2618516904678938844_group_thread_12> - 1 Update
>
> Hiring for Performance Tester w/ Java Environment Exp. in New York, NY
> 
> akshita mittal : Apr 25 04:19PM -0400
>
> *Position : Performance Tester w/ Java Environment Exp. *
>
>
>
> *Location : New York, NY Duration : 12+ Months Interview
> : Video conference.*
>
>
>
> In order to be considered candidates must have experience with the
> highlighted portion below. Education (including the school) and current
> location must be on the resume. Let me know if you have anyone.
>
>
>
> Working closely with the Analytics Platform teams, you will develop, build,
> improve and test market data analytics technology and infrastructure. You
> will develop and run calculation and stress tests. You will help evaluate
> prospective cloud-based technologies from the perspective of a fulfillment
> of a wide range of technical requirements and future inclusion in Analytics
> Platform itself.
>
>
>
> *Roles and Responsibilities *
>
> • Implement given use cases and other software against given
> specification
>
> • Create, execute and run load and performance tests in order to
> determine the performance of system under test against given criteria
>
> • Contribute to design and architecture of use cases and tests
>
> • Set up the tested systems and help assure sufficient orchestration
> and metrics
>
> • Produce software performance reports and comparison
>
>
>
> *Must have Skills*
>
> • Minimum bachelor’s Degree in computer science / Engineering or
> equivalent
>
> • Minimum 3 years of experience
>
> • Strong working knowledge of *Java, (familiarity with .net a plus)*
>
> • *Python or JavaScript scripting *
>
> • Strong problem solving, algorithmic thinking and coding skills
>
> • Experience with system setup automation (databases or other similar
> engine software)
>
> • Experience with *performance tuning and optimization*
>
> • A number of use cases, performance criteria, essentially they are
> going to be implementing these use cases
>
> • Ability to work in highly agile team environment
>
> • Self-driven, goal-oriented team player with good communication
> skills
>
> • Experience in development of complex. distributed, multi-tier
> systems
>
> • Experience with cloud environments, especially *AWS, a strong plus*
>
> • Experience in working with market data a plus
>
>
>
>
>
> *Regards , *
>
> *Akshita | ** KPG99,INC *
>
>
> *3240 E State, St
>  Ext |
> Hamilton, NJ 08619 609-681-2602 ||
> aksh...@kpgtech.com *
> akshita mittal : Apr 25 06:30PM -0400
>
> *Position : Performance Tester w/ Java Environment Exp. *
>
>
>
> *Location : New York, NY Duration : 12+ Months Interview
> : Video conferen

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(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,  wrote:

> excel-macros@googlegroups.com
> 
>  Google
> Groups
> 
> 
> Topic digest
> View all 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
> 
> vikas khen : 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 : Mar 07 08:05PM +0530
>
> PFA
>
> vikas khen : 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
> 
> Priti_Verma : 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
> 
> .
> 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.

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
> 
>  Google
> Groups
> 
> 
> Topic digest
> View all topics
> 
>
>- How to paste trendline equation from graph into a cell
><#m_931967116473658755_group_thread_0> - 1 Update
>- Formatting Output of Numbers for Printing to File
><#m_931967116473658755_group_thread_1> - 1 Update
>
> How to paste trendline equation from graph into a cell
> 
> 3xst...@gmail.com: Feb 24 12:00PM -0800
>
> Marek,
>
> The trendline equation is in a DataLabel object and you can get access to
> that text and insert it in a cell.
> So a quick and dirty way to do this is:
>
> Private Sub Test()
>
>
> ActiveSheet.ChartObjects("Chart 1").Activate
>
> Cells(1, 1) = ActiveChart.FullSeriesCollection(1).Trendlines(1).
> DataLabel.Text
>
>
> End Sub
>
> Note that this assumes you have only one chart in the worksheet. If you
> have more, you'll have to figure out which one it is.
>
> -Jim
>
> On Friday, February 23, 2018 at 2:14:22 AM UTC-5, Marek Adamech wrote:
> Back to top <#m_931967116473658755_digest_top>
> Formatting Output of Numbers for Printing to File
> 
> 3xst...@gmail.com: Feb 24 11:29AM -0800
>
> Hi all,
>
> This may be an easy one and I'm just not understanding formatting...
>
> I have calculations which give numbers like:
>
> 0.03799
> 9.89619
> 4.90005
> 0.01899
> 0.34994
>
> I'll be printing (or writing) data to a file using vba
> But the numbers I want are:
>
> 0.038
> 9.9
> 4.9
> 0.019
> 0.35
>
> Is there an obvious way to do this? I note when the numbers are in columns
> then the values I want show properly unless I widen the column. So Excel
> is doing some internal formatting in that case.
>
> Thanks in advance!
> -Jim
> Back to top <#m_931967116473658755_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
> 
> .
> 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.

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@googlegroups.com
> 
>  Google
> Groups
> 
> 
> Topic digest
> View all topics
> 
>
>- Urgent Need Business Analyst 2 (Columbus OH) 06+ Months
><#m_2017834070392865919_group_thread_0> - 1 Update
>- Excel Macro Help <#m_2017834070392865919_group_thread_1> - 2 Updates
>- Help with replacing formula with value over large range
><#m_2017834070392865919_group_thread_2> - 1 Update
>
> Urgent Need Business Analyst 2 (Columbus OH) 06+ Months
> 
> Javeed Khan : Dec 19 01:53PM -0500
>
> Please share profile on ja...@nestarit.com
>
> Direct contact number: (201) 448 1184
>
>
>
> This is *Javed Khan* from *NESTAR TECHNOLOGIES/ AESPATECH LLC* and we have
> an immediate requirement with our client where we have excellent hold and
> can close the positions pretty quick. If you find yourself comfortable with
> the requirement please reply back with your updated resume and I will get
> back to you or
>
> I would really appreciate if you can give me a call back at my contact
> number.
>
>
>
> We have a Requirement *Business Analyst 2 / BA2* position in *Columbus OH*.
> If you have any matching resumes for the below mentioned position.
>
>
>
> VERY URGENT AND IMMEDIATE NEED
>
>
>
> Job Title: Business Analyst 2 / BA2
>
> Location: *Columbus OH (Local)*
>
> Duration: 06+ Months Contract
>
> *Interview: INTERVIEW ONSITE ON WEDNESDAY*
>
>
>
> The Business Analyst is responsible for the set of tasks and techniques
> used to work as a liaison among stakeholders in order to understand the
> structure, policies, and operations of an organization, and to recommend
> solutions that enable the organization to achieve its goals.
>
>
>
> *Requirements:*
>
> • *Four to six years of experience with the following:*
>
> • Experience creating and coordinating technical documentation
> preparation and distribution for processes, projects and procedures.
>
> • Experience gathering, analyzing information needs and functional
> requirements from stakeholders, business owners, and customers.
>
> • Experience analyzing user needs and existing functions to
> determine business requirements, screen and interface design, use cases.
>
> • Experience providing ongoing system maintenance and evaluation of
> systems.
>
> • Experience delivering project artifacts.
>
> • Experience analyzing business requirements using interviews,
> document analysis, and workshops.
>
> • Analyzes, reviews, and recommends possible solutions to
> identified business problems.
>
> • Develop test scripts, test cases, for User Acceptance Testing
> (UAT) based on requirements.
>
> • Act liaison between business units, customers (internal and
> external) and various stakeholders.
>
> • Assist Project Manager in project planning and developing project
> task plans, leading JAD sessions.
>
> • Work experience in creating and coordinating technical,
> functional and business requirements for processes, projects and
> procedures.
>
> • Excellent communication both oral and written.- REQUIRED
>
>
>
> -
>
> *Warm Regards,*
>
> Javed Khan (Sr. Technical Recruiter)
>
> *NESTAR TECHNOLOGIES/ AESPATECH LLC*
>
> Direct: (201) 448-1153
>
> Email: ja...@nestarit.com
>
> Skype ID: javeedkhan.khan2
>
> GTalk: javeedimrank...@gmail.com ; javednesta...@gmail.com
>
> www.nestarit.com
>
>
>
> *Notice of Confidentiality:*
>
> The information contained herein is intended only for the confidential use
> of the recipient. If the reader of this message is neither the intended
> recipient, nor the person responsible for delivering it to the intended
> recipient, you are hereby notified that you have received this
> communication in error, and that any review, dissemination, distribution,
> or copying of this communication is strictly prohibited. If you receive
> this in error, please notify the sender immediately by telephone, and
> destroy this e-mail message OR reply with the subject *“REMOVE”* such that
> your email would be taken out of our distribution list.
> Back to top <#m_2017834070392865919_digest_top>
> Excel Macro Help
> 
> Julienne Schindler : Dec 19 12:29AM
>
> 
> On Mo

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
> 
> 
> Topic digest
> View all topics
> 
>
>- Process Flow Document for Dashboard designing
><#m_9075898574400075483_group_thread_0> - 1 Update
>- Links <#m_9075898574400075483_group_thread_1> - 1 Update
>
> Process Flow Document for Dashboard designing
> 
> Secret Shot : May 29 02:20PM +0530
>
> Hi Experts,
>
> I have recently joined a job where i have to design new dashboard for any
> new clients comes in.
>
> I am okay with dashboard designing, but my boss has asked me to define a
> proper process for dashboard designing , step wise step like discussion -
> data gathering - planning - designing etc. . .
>
> I want your help, if anyone have any such kind of dashboard designing
> process document.
>
> Pls Help.
>
> --
> Pankaj Pandey
> Bhopal
> Back to top <#m_9075898574400075483_digest_top>
> Links
> 
> Minta Spriggs : May 29 08:39AM
>
> 
> On Fri, 5/26/17, KAUSHIK SAVLA  wrote:
>
> Subject: Re: $$Excel-Macros$$ Links
> To: "MS EXCEL AND VBA MACROS" 
> Date: Friday, May 26, 2017, 10:10 PM
>
> Hi Paul,
>
>
> I followed the instructions.
>
> However what's happening is the macro
> is just showing running and not giving any outcome.
>
> I kept it running for nearly 3 hours.
>
> Regards,
> Kaushik
>
> --
> 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+unsubscribe@
> 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.61in extrema stanga a vietii politice
> interbelice s-au aflat comunistii. De fapt idul Comunist din Romania a
> actionat ca sectie a Cominternului. in 1920 in ui Partidului Socialist a
> existat o confruntare intre opinia constituirii unui d comunist si
> afilierea la Comintern si cea a unificarii intregii miscari citoresti si
> apoi afilierea sa la forul mai sus mentionat. in toamna lui 1920 o gatie a
> socialistilor romani a vizitat Rusia Sovietica unde a discutat conditiile
> fii la organismul comunist mondial. Neacceptarea lor de catre losif anca
> loan Flueras G. Grigorovici a dus ulterior la excluderea lor din jucerea
> socialista sub presiunea elementelor stangiste. La 8 mai 1921 lentele de
> extrema stanga din Partidul Socialist au pus bazele Partidului nunist.
> Partidul Socialist s-a disociat de acesta. Autoritatile constiente de O|UI
> reprezentat de noua organizatie au intervenit si au arestat pe unii cipanti
> la Congresul de constituire. in 1922 a avut loc totusi la Ploiesti gresul
> al II la care au participat 34 delegati.
> Back to top <#m_9075898574400075483_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
> 
> .
> To unsubscribe from this group and stop receiving emails from it send an
> email to excel-macros+unsubscr...@googlegroups.com.
>



-- 
Thanks,
David

-- 
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/discus