Re: $$Excel-Macros$$ Re: Help with replacing formula with value over large range

2017-12-19 Thread who 
Sub CopyPastVal()
Cells.Copy
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub

Thanks, David

On Sunday, December 17, 2017 at 12:12:31 AM UTC-8, Ravi K wrote:
>
> Thanks David.
> Will try to incorporate this into the macro.
>
> Cheers
> Ravi
>
> On 17 Dec 2017 7:20 am, "who"  wrote:
>
>> Might try this too. Thanks, David
>>
>> Sub CopyPasteAll()
>> Cells.Select
>> Selection.Copy
>> Selection.PasteSpecial Paste:=xlPasteValues
>> ActiveSheet.Paste
>> Application.CutCopyMode = False
>> ActiveCell.Select
>> End Sub
>>
>> On Friday, December 15, 2017 at 10:14:17 PM UTC-8, Ravi K wrote:
>>>
>>> Hi
>>>
>>> Can someone please explain why this macro does not work
>>> I have no formal training in VB or any programming so everything in the 
>>> macro is bits taken from various posts
>>>
>>> What I need to do is put 1 or 0 over a range that starts at B8 and ends 
>>> at the last column  with data at row 44652
>>> but if I leave the formula "=IF(AND(RC1>R4C,RC1>> the workbook becomes too large and  my i5 laptop hangs so I have to convert 
>>> the formula into the result value 1 or 0
>>>
>>> ===
>>> Sub FillCellsMyRange()
>>>
>>> ' Change the WorkSheet Name
>>> Dim shName As String
>>> Dim currentName As String
>>> currentName = ActiveSheet.Name
>>> shName = "MINUTES"
>>> If currentName <> shName Then
>>> ThisWorkbook.Sheets(currentName).Name = shName
>>> End If
>>>
>>> Dim LastCol As Long
>>> With ActiveSheet.UsedRange
>>> LastCol = .Columns(.Columns.Count).Column
>>> End With
>>> Dim LastRow As Long, Rng1 As Long
>>> LastRow = Cells.Find(What:="*", After:=Range("A1"), 
>>> SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
>>>
>>> 'Set Rng1 = Sheets("MINUTES").Range("B8:" & LastCol &  "44652")
>>> 'ActiveWorkbook.Names.Add Name:="MyRange", RefersTo:=Rng1
>>>
>>>
>>> ' Turn off screen updating to improve performance
>>> Application.ScreenUpdating = False
>>> On Error Resume Next
>>>
>>>
>>> ' Look in column B
>>> With Sheets("MINUTES").Range("B8:" & LastCol & LastRow)
>>> ' For blank cells, set them to equal the cell above
>>> .SpecialCells(xlCellTypeBlanks).Formula = 
>>> "=IF(AND(RC1>R4C,RC1>> 'Convert the formula to a value
>>> .Value = .Value
>>> End With
>>> Err.Clear
>>> Application.ScreenUpdating = True
>>> End Sub
>>> =
>>>
>>> again, nothing above is original work, it is all copy & paste of what 
>>> looked like useful bits from various answers on various groups 
>>>
>>> Thanks again
>>>
>>> Ravi
>>>
>>>
>>> -- 
>> 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 a topic in the 
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit 
>> https://groups.google.com/d/topic/excel-macros/Su5gKtzlr4U/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to 
>> excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>

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

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 :

$$Excel-Macros$$ Urgent Need Business Analyst 2 (Columbus OH) 06+ Months

2017-12-19 Thread Javeed Khan 
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.

-- 
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$$ Excel Macro Help

2017-12-19 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS 


On Tue, 12/19/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS 
 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 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Excel
 Macro Help
  To: "MS EXCEL AND VBA MACROS" 
  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+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.ascoala dteSc 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.

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