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
End If
Else
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
Fr
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?
>
>
Probably the most efficient to do only those with formulas
option explicit
Sub dovalues()
dim ws as worksheet
For Each ws In ActiveWorkbook.Sheets
With ws.Cells.SpecialCells(xlCellTypeFormulas)
.value = .Value
End With
Next ws
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: d
11 matches
Mail list logo
