LinkBack URL
About LinkBacks
I have two worksheets ( sheet 1, sheet 2) for sheet 2 I want all my messy formulas and other algorithms to go into. For sheet 1 I just want nice clean outputs that have been generated by sheet 2. What is the call procedure for that.
Copy/Paste
I have two worksheets ( sheet 1, sheet 2) for sheet 2 I want all my messy formulas and other algorithms to go into. For sheet 1 I just want nice clean outputs that have been generated by sheet 2. What is the call procedure for that.
Hi, try this code in a VBA module:
You can then run it from the macros list (Tools -> Macros...)
Sub copyValuesAndFormats() Sheets("Sheet2").Cells.Copy Sheets("Sheet1").Cells.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, _ Operation:=xlNone, SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks