Re: $$Excel-Macros$$ Values 2 New

2012-05-17 Thread Aamir Shahzad
; excel-macros@googlegroups.com] *On Behalf Of *Aamir Shahzad > *Sent:* 18 May 2012 1:13 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Values 2 New > > > > thanks rajan for your expertise. But if format started from B2 to H10 when > run the code, s

Re: $$Excel-Macros$$ Values 2 New

2012-05-17 Thread Aamir Shahzad
t; > > Set wksSheet = Nothing > > End Sub > > > > > > > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *

RE: $$Excel-Macros$$ Values 2 New

2012-05-17 Thread Rajan_Verma
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: 18 May 2012 12:56 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Values 2 New ok Rajan now code is working fine but it's removing the formating. Aamir Shahzad On Fri, Ma

Re: $$Excel-Macros$$ Values 2 New

2012-05-17 Thread Aamir Shahzad
M-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Aamir Shahzad > *Sent:* 18 May 2012 12:52 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Values 2 New > > > > Screenshot is a

RE: $$Excel-Macros$$ Values 2 New

2012-05-17 Thread Rajan_Verma
ot of Error? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: 18 May 2012 12:46 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Values 2 New Don, Your mac

RE: $$Excel-Macros$$ Values 2 New

2012-05-17 Thread Rajan_Verma
@googlegroups.com Subject: Re: $$Excel-Macros$$ Values 2 New Don, Your macro is convert the sheet to values only not creating copy of sheet. Rajan, Your macro is showing error. Regards, Aamir Shahzad On Thu, May 17, 2012 at 10:37 PM, Rajan_Verma wrote: Try this One: Sub

Re: $$Excel-Macros$$ Values 2 New

2012-05-17 Thread Aamir Shahzad
> > End Sub > > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > > > *From:* Aamir Shahzad > > *Sent:* Thursday, May 17, 2012 12:15 PM > > *To:* excel-macros@googlegroups.com > > *Subject:* $$Excel-Mac

RE: $$Excel-Macros$$ Values 2 New

2012-05-17 Thread Rajan_Verma
legroups.com Subject: Re: $$Excel-Macros$$ Values 2 New Sub makevalues() ActiveSheet.UsedRange.Value = _ ActiveSheet.UsedRange.Value End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad <mailto:aamirshahza...@gmail.com> Sent: Thurs

Re: $$Excel-Macros$$ Values 2 New

2012-05-17 Thread dguillett1
Sub makevalues() ActiveSheet.UsedRange.Value = _ ActiveSheet.UsedRange.Value End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Thursday, May 17, 2012 12:15 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Values 2 New Dear

$$Excel-Macros$$ Values 2 New

2012-05-17 Thread Aamir Shahzad
Dear Group, Macro required which generate the same copy of sheet but values only. Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,