; 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
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 *
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
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
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
@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
o:
> excel-macros@googlegroups.com] *On Behalf Of *dguillett1
> *Sent:* 17 May 2012 11:01
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Values 2 New
>
>
>
> Sub makevalues()
>
> ActiveSheet.UsedRange.Value = _
>
> ActiveSheet.UsedRange.Value
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
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 G
