-------------------------------------------- On Thu, 12/21/17, 'Yu Spain' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote:
Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics To: excel-macros@googlegroups.com Date: Thursday, December 21, 2017, 6:13 AM -------------------------------------------- On Wed, 12/20/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics To: excel-macros@googlegroups.com Date: Wednesday, December 20, 2017, 9:19 PM -------------------------------------------- On Wed, 12/20/17, David Lanman <david.lanm...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4 updates in 3 topics To: excel-macros@googlegroups.com Date: Wednesday, December 20, 2017, 1:56 AM 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 = FalseEnd SubThanks, David On Tue, Dec 19, 2017 at 3:31 PM, <excel-macros@googlegroups.com> wrote: excel-macros@googlegroups.com Google Groups Topic digest View all topics Urgent Need Business Analyst 2 (Columbus OH) 06+ Months - 1 Update Excel Macro Help - 2 Updates Help with replacing formula with value over large range - 1 Update Urgent Need Business Analyst 2 (Columbus OH) 06+ Months Javeed Khan <javed.businessanalyst@gmail. com>: 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 Excel Macro Help Julienne Schindler <julienneschind...@yahoo.com>: Dec 19 12:29AM ------------------------------ -------------- On Mon, 12/18/17, V <vianeyespinosa@nvo2. grandluxxe.com> wrote: Subject: Re: $$Excel-Macros$$ Excel Macro Help To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com > Date: Monday, December 18, 2017, 7:56 PM Hi, do you know how can I get using validations in Google Drive that change the color by codes. El miércoles, 11 de octubre de 2017, 11:40:37 (UTC-5), GENIUS escribió:look at the attachment, I can do only this. -- 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. ublicul va lua cunostinta de ele abia in anii '80 ai secolului nostru ele Kenyatta Freed <kenyattafr...@yahoo.com>: Dec 19 05:16PM ------------------------------ -------------- On Tue, 12/19/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com > wrote: Subject: Re: $$Excel-Macros$$ Excel Macro Help To: excel-macros@googlegroups.com Date: Tuesday, December 19, 2017, 3:29 AM ------------------------------ -------------- On Mon, 12/18/17, V <vianeyespinosa@nvo2. grandluxxe.com> wrote: Subject: Re: $$Excel-Macros$$ Excel Macro Help To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com > Date: Monday, December 18, 2017, 7:56 PM Hi, do you know how can I get using validations in Google Drive that change the color by codes. El miércoles, 11 de octubre de 2017, 11:40:37 (UTC-5), GENIUS escribió:look at the attachment, I can do only this. -- 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. ublicul va lua cunostinta de ele abia in anii '80 ai secolului nostru ele -- 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.ascoala d<n 190? si vo-'-ih i. v>teSc sale In v>-h > socia!-poiitrca a maniei.Rascoala din 1907 a constituit apogeul miscarilor sociale de la finele >cii modeme ce s-a remarcat printr-o amploare intensitate grad de violenta irindere si caracter exploziv fara precedent. Unii contemporani au intrevazut a un veritabil razboi taranesc ce a impus cu stringenta necesitatea rezolvarii blemei agrare. Back to top Help with replacing formula with value over large range Ravi K <rk5...@gmail.com>: Dec 18 11:26PM -0800 Sub chkdt() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim rw, cl, i, q As Double 'rw - no of used rows, cl - no of used column, i - lookup for row,q - lookup for column Dim dif, t, dt As Long t = 4 dt = 5 rw = ThisWorkbook.Sheets("MINUTES") .Range("A" & Rows.Count).End(xlUp).Row cl = ThisWorkbook.Sheets("MINUTES") .Range("A1").End(xlToRight). Column ThisWorkbook.Sheets("MINUTES") .Range(Cells(8, 2), Cells(rw, cl)).Clear For q = 2 To cl ' column lookup For i = 8 To rw ' row loookup dif = Round((ThisWorkbook.Sheets(" MINUTES").Cells(dt, q) - ThisWorkbook.Sheets("MINUTES") .Cells(t, q)) * 24 * 60, 0) - 1 If (ThisWorkbook.Sheets("MINUTES" ).Cells(i, 1) >= ThisWorkbook.Sheets("MINUTES") .Cells(t, q)) And _ (ThisWorkbook.Sheets("MINUTES" ).Cells(i, 1) < ThisWorkbook.Sheets("MINUTES") .Cells(dt, q)) Then DoEvents ThisWorkbook.Sheets("MINUTES") .Range(Cells(i, q), Cells(i + dif, q)) = 1 i = rw End If Next i Next q MsgBox "completed" Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic End Sub ====================== Thanks to everyone who helped Cheers Ravi On Saturday, December 16, 2017 at 11:44:17 AM UTC+5:30, Ravi K wrote: Back to 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+unsubscribe@ 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/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. entiem de alte culturi europene? pana unde merge inrudirea noastra spirituala cu alte natiuni si unde apare elementul caracteristic diferenta specifica? ce aducem original in cultura Europei si care este obarsia acelor trasaturi care ne singularizeaza fara a ne izola totusi?. Aceasta problematica pe care o prefigurau cateva personalitati active in deceniile precedente Vasile Alecsandh ca folclorist Bogdan Petriceicu Hasdeu in studii de istorie etnografie si lingvistica Nicolae Densusianu in Dacia preistorica capata amploare dupa implinirea vechiului vis al unitatii nationale materializandu-se in creatii care la prima vedere cu greu se pot plasa sub acelasi stindard. -- 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.onea Emilia Sonea Gavrila Viata economica si politica a Romaniei 1933-1938 Editura stiintifica si Enciclopedica Bucuresti 1978. -- 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.1 aug. - Debutul grevei regale . Regele Mihai refuza sa colaboreze cu guvernul Groza. -- 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.
