You can try Application.calculation = xlMannual , if calculation is not
required everytime
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of vijayajith VA
Sent: Feb/Fri/2012 11:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ paste
: $$Excel-Macros$$ paste special problem
Hi Danial,
If you are not done with your task, you may want to consider this variation on
Don's approach. It's not thoroughly tested, but some of the changes should
improve reliability.
The principle differences:
(1) Processes Areas
ws.Cells.SpecialCells(xlCellTypeFormulas)
.Value = .Value
End With
Next ws
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: danial mansoor
Sent: Saturday, February 04, 2012 5:01 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ paste special problem
Option
e
End Sub
From: dguille...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ paste special problem
Date: Fri, 3 Feb 2012 15:18:36 -0600
Show me.
Don
Guillett
SalesAid Software
dguille...@gmail.com
From: danial mansoor
Sent: Friday, February 03, 2012 3:07
Debug.Print "Skipping hidden workbook " & wb.FullName
End If
Next wb
Debug.Print vbCrLf & ProcTitle & " Finish."
Cleanup:
Set a = Nothing
Set ws = Nothing
Set wb = Nothing
End Sub
Asa
From: excel-macros@googlegroups.com [mailto:exce
Show me.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: danial mansoor
Sent: Friday, February 03, 2012 3:07 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ paste special problem
thanx,your work fine with with little changes
thanx,your work fine with with little changes.
From: dguille...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ paste special problem
Date: Fri, 3 Feb 2012 14:33:36 -0600
Run mine
Don
Guillett
SalesAid Software
dguille...@gmail.com
From: danial
Run mine
Don Guillett
SalesAid Software
dguille...@gmail.com
From: danial mansoor
Sent: Friday, February 03, 2012 2:09 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ paste special problem
in this i have t select each sheet is there a way i run macro and every sheet
get
in this i have t select each sheet is there a way i run macro and every sheet
get updated with values and no formula shown?bt plz consider huge file
Date: Fri, 3 Feb 2012 23:47:03 +0530
Subject: Re: $$Excel-Macros$$ paste special problem
From: vijayajith...@gmail.com
To: excel-macros
Hi mansoor,
sub tex()
selection.value = selection.value
end sub
On Fri, Feb 3, 2012 at 9:08 PM, danial mansoor wrote:
> i have a big file with many sheets i want to convert formula in values,if
> i do individually it will take lotes of time can any one tell me the macro
> which will work?
>
>
: danial mansoor
Sent: Friday, February 03, 2012 9:38 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ paste special problem
i have a big file with many sheets i want to convert formula in values,if i do
individually it will take lotes of time can any one tell me the macro which
i have a big file with many sheets i want to convert formula in values,if i do
individually it will take lotes of time can any one tell me the macro which
will work?
Note:macro should work fine in huge file i have a macro which is working fine
with small file but not in huge file urgent help w
12 matches
Mail list logo
