neboland
02-13-2021, 02:45 AM
Hi all,
This is my first thread.
I need help to solve next issue:
I want to copy data from one sheet to new - every time i press button (start macro) i will have pasted data in new sheet. Code i have is excellent and works:
Sub Macro1()
Dim ws As Worksheet
Set ws = ActiveSheet
Sheets.Add after:=Worksheets(Worksheets.Count)
ws.UsedRange.Copy ActiveSheet.Range("A1")
End Sub
what i want: When paste data in new sheet i need only values without formulas or connection. (when i click "refresh all", i dont want to change pasted values, just to change original table).
Thanks in advance
This is my first thread.
I need help to solve next issue:
I want to copy data from one sheet to new - every time i press button (start macro) i will have pasted data in new sheet. Code i have is excellent and works:
Sub Macro1()
Dim ws As Worksheet
Set ws = ActiveSheet
Sheets.Add after:=Worksheets(Worksheets.Count)
ws.UsedRange.Copy ActiveSheet.Range("A1")
End Sub
what i want: When paste data in new sheet i need only values without formulas or connection. (when i click "refresh all", i dont want to change pasted values, just to change original table).
Thanks in advance