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, <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>
>
> - 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
> <http://groups.google.com/group/excel-macros/t/400ea0f179dfbe06?utm_source=digest&utm_medium=email>
> Javeed Khan <javed.businessanal...@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 <#m_2017834070392865919_digest_top>
> Excel Macro Help
> <http://groups.google.com/group/excel-macros/t/86ba0dc8bc1dbfab?utm_source=digest&utm_medium=email>
> Julienne Schindler <julienneschind...@yahoo.com>: Dec 19 12:29AM
>
> --------------------------------------------
> On Mon, 12/18/17, V <vianeyespin...@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+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.
> 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 <vianeyespin...@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+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.
> 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 <#m_2017834070392865919_digest_top>
> Help with replacing formula with value over large range
> <http://groups.google.com/group/excel-macros/t/4aee602adce5af85?utm_source=digest&utm_medium=email>
> 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 <#m_2017834070392865919_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.
>
--
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.
