Macro
Closed
jem11231
Posts
2
Registration date
Wednesday March 3, 2010
Status
Member
Last seen
March 3, 2010
-
Mar 3, 2010 at 01:37 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 3, 2010 at 03:46 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 3, 2010 at 03:46 PM
Related:
- Macro
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Run macro on opening workbook - Guide
- Excel vba assign macro to button programmatically - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 3, 2010 at 03:46 PM
Mar 3, 2010 at 03:46 PM
Depends on what you want to do with parameter and how they are being used. In general this should do it
sub formulaFix()
range("a2:f2").select
Selection.Copy
Range("a3").Select
ActiveSheet.Paste
range("a2:f2").select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
end sub
sub formulaFix()
range("a2:f2").select
Selection.Copy
Range("a3").Select
ActiveSheet.Paste
range("a2:f2").select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
end sub
